Sled
HomeBlog
  • Welcome to Sled
  • Sled for Business Users (Viewer)
  • Sled for Data Users (Editors)
    • Checks
    • Data Profiles
    • Lineage and Data Flows
  • Connect with Snowflake
    • Grant permissions on future tables
    • Background Tasks for Snowflake
    • Configure Paths for Snowflake Background Tasks
    • Enabling SSO on Snowflake
  • Other Integrations
    • Tableau
    • PowerBI
    • Qlik
    • Looker
    • dbt
Powered by GitBook
On this page

Was this helpful?

  1. Other Integrations

PowerBI

PreviousTableauNextQlik

Last updated 6 months ago

Was this helpful?

PowerBI App Registration, Permission

Go to Azure AD App registration, add “New registration”

Default selection is fine, add a name

Write down Application (Client ID)

Add a client secret, change the duration to an appropriate amount. Client secret has to be recreated each time it runs out and must also be changed in Snowboard afterwards

Write down Value, this is the Client secret for Snowboard

Go to API permissions

Add “Application Permissions” → “Tenant.Read.All” 
Add “Application Permissions” → “Report.Read.All” 
Add “Application Permissions” → “Report.ReadWrite.All”

Grant admin consent

Today Admin endpoints needed

https://api.powerbi.com/v1.0/myorg/admin/groups

Get AzureAD Tenant ID ()

Shouldn’t be necessary, but for completeness sake: Go to } and grant permissions

https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-how-to-find-tenant
https://login.microsoftonline.com/{tenant-id}/adminconsent?client_id={client-id
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-reports-in-group-as-admin