Access Condeco data with Power BI
Prerequisites
- Condeco Analytics Advanced subscription. Learn more: Condeco Analytics Advanced
- An active Power BI account. Learn more: https://powerbi.microsoft.com/en-us/.
- SQL connection details.
Download and install Power BI desktop
Download and install the Power BI desktop from https://powerbi.microsoft.com/en-us/desktop/.
Connect to your Condeco data
Open Power BI and connect to your Condeco data:
- Launch Power BI and select SQL Server as the data source.
- Enter the Server and Database names and select the Data Connectivity mode:
- Import: Download the data locally and create your own data lake.
- DirectQuery: Access the data directly from the database.
- Click OK
- Select Database on the left, enter the username and password for the database, and click Connect.
The Navigator opens and displays the data tables. Learn more: Direct data connection tables
Learn more
Visit the following websites to learn more about Power BI and how to design your reports:
- Designing your report: docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report#step-3-design-your-report/
- Publish desktop report to portal: docs.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files/
Scheduled refresh
Apply a scheduled refresh in Power BI portal to keep the data and reports up-to-date.
Refreshing data can take a considerable amount of time and therefore be done as infrequently as makes sense for your reporting needs.
More information is available on the following websites:
- How to configure scheduled refresh: docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh/.
- Incremental refresh for Power BI Premium users: powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#premium