Microsoft Power BI

Download PDF

Some customers use Microsoft Power BI for building reports. Because we care about privacy, we don’t store any personal data. No personal data from your visitors will end up on the servers of Microsoft.

This connector lets customers query data from the API of Simple Analytics.

1. Before you start, you will need the export URL from your Simple Analytics dashboard. Select the fields you want in the export and select “CSV”:

   

2. Copy the URL with a right mouse, click on the “Export” button and select “Copy link” (or something like that). Save this link for a later step.

3. Add a data connector in Power BI by selecting the web connector:

   

4. After you hit “Connect” select the “Advanced” option

   

5. In the URL parts, you can add the URL you copy the link you copied from the “Export” button.

6. You can decide to break the URL up into parts by adding, for example, the dates programmatically

7. Finally, you have to fill in two headers (get from your account page):

   • User-Id: sa_user_id_00000000-0000-0000-0000-000000000000
   • Api-Key: sa_api_key_xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

8. Hit “Ok” and on the next screen, click “Transform Data”:

   

9. You will have the Simple Analytics data in Microsoft Power BI. The possibilities are endless. That’s why we stop the guide here for now.

We are planning to extend this guide to include an entire automatic updating data store in Power BI.

Let us know if you plan to implement that. Happy to help!