How to integrate PowerBI with Sapho version 3.9 or greater

Last update:

Step 1: Sign in

Log in to powerbi.microsoft.com with an account that has access to the reports and/or dashboards you would like to display in Sapho.

Step 2: Go to Power BI for Developers page

Go to dev.powerbi.com/apps. Make sure to sign in with the correct Power BI account.

Step 3: Add details about your app

Fill in App Name.

Set App Type to Server-side Web app.

Set Redirect URL to https://auth.sapho.com/callback.

Set Home Page URL to https://www.sapho.com.

step2.png
Step 4: Choose APIs to access

Choose the following APIs to access:

  • Dataset APIs - Read All Datasets.
  • Report and Dashboard APIs - Read All Dashboards, Read All Reports.
  • Other APIs - Read All Groups.

step3.png

Step 5: Register your app

Click the Register App button in the last step on the page and wait until you get credentials for your application. Save them in a secure place for future reference.

step4.png

Step 6: Paste the credentials

Paste the Client ID and Client Secret you obtained at at Step 5 in the respective input fields of the connector configuration form for PowerBI in Sapho. Click Next.

Step 7: Log in with the PowerBI account

Make sure that you use the account has access to the reports and/or dashboards you would like to display in Sapho.

Please note that if you’re hosting Sapho on an internal server which is behind a firewall, you will need to allow access to hostname www.microsoft.com with port 443, so Sapho can connect to the PowerBI cloud.

Click Next.

Step 8: Finish the creation of the connector

 

Audit Trail

Once you have created a dedicated account in PowerBI and set up the connector in Sapho using that account, you will be able to ensure transparency in your audit logs.