Step 1: Sign in
Log in to powerbi.microsoft.com with an account that has access to the reports and/or dashboards you want to access through 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 and Home Page URL.
Set App Type to Server-side Web app.
Set Redirect URL to https://auth.sapho.com/callback.
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 values in the input fields of Power BI connector definition in Sapho.