How to integrate PowerBI with Sapho version 3.9 or greater

Last update:

Step 1: Sign in

Log in to 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 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

Set Home Page URL to

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.


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.


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 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.