When you want to use data collected by Piwik PRO in Microsoft Power BI Desktop, 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 Desktop.
To integrate with Microsoft Power BI Desktop, follow these steps:
Note: This integration is in beta and isn’t listed in Microsoft Power BI extensions yet. We plan to publish it there soon. Until then, you need to add the extension manually.
- Update your Microsoft Power BI Desktop to the latest version.
- Download the .mez file with our connector.
- On your computer, find the following directory:
My Documents\Microsoft Power BI Desktop\Custom Connectors. If the directory doesn’t exist, create one.
- Add the downloaded file with our connector to the folder
Custom Connectorsin the found directory:
My Documents\Microsoft Power BI Desktop\Custom Connectors.
- Open your Microsoft Power BI Desktop.
- Go to File > Options and settings > Options > Security.
- In Data Extensions, check Allow any extension to load without validation or warning.
- Click Save.
- Done! Now the extension is available in your Microsoft Power BI Desktop, and you can connect to Piwik PRO.
- Create a new workbook or data source.
- Click Get Data.
- Look for Piwik PRO Analytics. This is our connector.
- Click Connect.
- Click Continue.
- In Account address, enter your account address.
Tip: Your account address is the URL you use to log in to Piwik PRO. Example:
- Click OK.
- Next, enter your Client ID and Client secret. Where to find it?
- Click Connect.
- In Navigator, select the site or app from which you want to get data.
- Select the data format you want to download:
- Raw data: Allows you to download raw session and event data.
- Reports: Allows you to query the database and download data, just like reports in Piwik PRO.
- Enter the start date and optional end date.
Note: If you don’t enter an end date, our connector will automatically set the current date and you’ll be able to use the Refresh button to trigger the download of the latest data.
- (Optional) Select the dimensions, metrics and other parameters you want to see in Power BI.
- If you picked the report data format and want to use dates, you’ll need to select the Timestamp dimension. In raw data, these dates are automatically included. Read more
- You could get a
400: Bad requesterror if you try to combine dimensions and metrics that can’t be used together in one query because of conflicting scopes. Read more
- The following data can’t be imported because its format doesn’t match the column structure: sessions_goals, sessions_goal_uuid and all product-scoped dimensions.
- Click OK.
- Click Apply to see the preview.
Note: If you select too much data, the preview may not work.
- Click Load to load all data or Transform Data if you want to do some transformations first.
- All done! Your data will soon appear in Microsoft Power BI Desktop.