Microsoft Power BI Desktop integration (beta)

Needed permissions: owner, manage, edit & publish or edit

Note: This integration is for Microsoft Power BI Desktop only. We plan to release the integration for Microsoft Power BI service in a few months.

When you want to use data collected by Piwik PRO in Microsoft Power BI, you need to use our custom data connector in Microsoft Power BI. After the integration is done, you can start creating powerful data visualizations on dashboards and reports in Microsoft Power BI.

Microsoft Power BI Desktop integration in Piwik PRO

To integrate with Microsoft Power BI, 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.

  1. Update your Microsoft Power BI Desktop to the latest version.
  2. Download the file with our connector.
  3. On your computer, find this directory: My Documents\Microsoft Power BI Desktop\Custom Connectors. If the directory doesn’t exist, create one.
  4. Add the downloaded file with our connector to the folder Custom Connectors in the found directory: My Documents\Microsoft Power BI Desktop\Custom Connectors.
  5. Open your Microsoft Power BI Desktop.
  6. Go to File > Options and settings > Options > Security.
  7. In Data Extensions, check Allow any extension to load without validation or warning.
    Microsoft Power BI Desktop integration in Piwik PRO
  8. Click Save.
  9. Done! Now the extension is available in your Microsoft Power BI Desktop, and you can connect to Piwik PRO.
  10. Create a new workbook or data source.
  11. Click Get Data.
    Microsoft Power BI Desktop integration in Piwik PRO
  12. Look for Piwik PRO Analytics. This is our connector.
  13. Click Connect.
  14. Click Continue.
  15. In Account name, enter your account name.
    Microsoft Power BI Desktop integration in Piwik PRO

    Tip: Your account name is the first part of your account address: example in example.piwik.pro. For custom domains, check your account name under Piwik PRO > Menu > Administration > Settings > Subscription.

  16. In Site or app ID, enter the ID. Where to find it?
    Microsoft Power BI Desktop integration in Piwik PRO
  17. Add a start date and end date in the YYYY-MM-DD format. Example: 2021-12-01.
    Microsoft Power BI Desktop integration in Piwik PRO

    Tip: To test your connection, choose data from just one or two days. There’ll be less data to download.

  18. In Data scope, choose Session or Event.
    Microsoft Power BI Desktop integration in Piwik PRO

    Tip: You’ll download all raw data for a session or event scope. If you want to work on data from a selected report, export it as a CSV file and import this file to Microsoft Power BI.

  19. Click OK.
  20. On the confirmation screen, enter your client ID and client secret. Where to find it?
  21. Click Confirm.
  22. All done! Your data will soon appear in Microsoft Power BI Desktop.
    Microsoft Power BI Desktop integration in Piwik PRO
  23. Click Load to load all data or Transform Data if you want to do some transformations first.

Was this article helpful?

Technical support

If you still have some questions, visit our community.
There’s always someone ready to help!

Back to help center