Microsoft Power BI Desktop integration (beta)

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.

To integrate with Microsoft Power BI, follow these steps:

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.
   

   

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.
    

    

12. Look for Piwik PRO Analytics. This is our connector.
13. Click Connect.
14. Click Continue.
15. In Account name, enter your account name.
    

    

    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?
    

    

17. Add a start date and end date in the YYYY-MM-DD format. Example: 2021-12-01.
    

    

    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.
    

    

    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.
    

    

23. Click Load to load all data or Transform Data if you want to do some transformations first.