Note: This integration is in beta and requires a Power BI Desktop account. We plan to release a built-in integration for Microsoft Power BI service soon.
When you want to use data collected by Piwik PRO in Microsoft Power BI service, you need to use our custom data connector. Once the integration is complete, you can start creating powerful data visualizations on dashboards and reports in Microsoft Power BI service.
To integrate with Microsoft Power BI service, follow these steps:
- Install an on-premises data gateway on the server. The gateway helps you access data on that server.
- Download the .mez file with our connector and add it to any folder on the server.
- Turn on custom connectors in the on-premises data gateway and point to the added folder as the location for custom connectors.
- On your computer, open Microsoft Power BI Desktop. At this point, you should already have the integration with the desktop version set up. If you haven’t already done so, see these instructions.
- Connect to the Piwik PRO Analytics data source and download the data you want.
- (Optional) If you want to use incremental refresh, follow the next optional steps.
- (Optional) First, follow these steps from Microsoft.
- (Optional) In the Filter data step, set a filter for the Date column. Don’t publish your report yet.
- (Optional) On the Home ribbon in Power Query Editor, select Advanced Editor.
- (Optional) Find the function call that loads the data and replace the first two date parameters with
DateTime.Date(RangeStart),DateTime.Date(RangeEnd)respectively.
- (Optional) Click Done.
- Publish the dataset and report from Power BI Desktop to Power BI service.
- Log in to Power BI Service.
- Go to Settings > Manage connections and gateways.
- In Connections, click New to create a new connection.
- Select On-premises.
- Select your Gateway cluster name and name your connection.
- In Connection type, select Piwik PRO Analytics.
- In Account address, enter your account address.
Tip: Your account address is the URL you use to log in to Piwik PRO. Example:
https://example.piwik.pro. - In Authentication, enter the following information:
- Username: Client ID (Where to find it?)
- Password: Client secret (Where to find it?)
- Click Create.
- Open the workspace where you published your dataset and report.
- Find your published dataset and click the ⋯ three-dot icon.
- Select Settings.
- In Gateway connections, map the data source to the connection and click Apply.
- In Refresh, set a refresh schedule and click Apply.
- Reopen the workspace and click Refresh Now to trigger a dataset refresh.
- Job done! Now your data is automatically refreshed in Power BI service. You can also publish reports from Power BI Desktop or create and edit reports in Power BI service.