How to integrate PowerBI with Sapho version 3.9 or greater
Category: Integration Setup
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
Set Home Page URL to
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
www.microsoft.com with port 443, so Sapho can connect to the PowerBI cloud.
Step 8: Finish the creation of the connector
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.