Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

In order to connect WIP to Power BI we need to create an application registration in the Azure Entra ID

WIP will connect to this application that will act as a service principal in PowerBI

We need to add the application / service principal to each workspace / workspace WIP will publish, to be able to add / publish items

WIP is able to rebind report to any destination dataset during the publish phase

WIP is able to remap semantic model datasources during the publish phase

Checkout can be done:

  • on the service on my workspace (only me will modify)

  • on the service on a shared workspace for collaborate editing

  • on you desktop using the WIP Desktop App

Create Application Registration

image-20250116-022630.png

image-20250108-020915.png

  • Name : your application name (service principal name also)

  • Redirect Url : where to redirect after azure authentication = WIP external URL

Press Register.

Api Permissions

Once created go to API Permissions and use “+Add a permission“ to add permissions

image-20250116-023221.png

image-20250116-023415.png

  • Microsoft Graph (import users)

    • User.Read

  • Power BI Service

    • Application permissions (Admin consent required)

      • Tenant.ReadWrite.All

    • Delegated Permissions

      • Connection.ReadWrite.All

      • Dataset.ReadWrite.All

      • Gateway.ReadWrite.All

      • Item.ReadWrite.All

      • PaginatedReport.ReadWrite.All

      • Report.ReadWrite.All

      • SemanticModel.ReadWrite.All

      • Workspace.ReadWrite.All

After adding the permissions you our a active directory admin should press the button “Grant Admin Consent for …“ in order to validate the Status to Granted for your company

The app permissions should look like this after:

image-20250108-021638.png

Screen Recording 2025-01-08 at 10.18.48.mov

Assign Service Principal to Workspaces manually

You need to assign the service principal (registered application) you just created to all workspaces you want to control with WIP (my workspaces is not necessary as they will be accessed using the login user)

You can do it manually for each workspace or you can do it in the admin portal

image-20250108-235501.png

Assign Service Principal to Workspaces in Admin Portal

image-20250116-025119.png

Add service principal to fabric administrative group

image-20250109-111414.png

You need to add your service principal to a group (that you might create) having assigned roles = “Fabric Administrator”

Connect WIP to Power BI

In WIP create a new Power BI Server

Known Errors

The caller is not authenticated to access this resource Status: 401 (Unauthorized) 

  • Add the service principal to a group having assigned roles = Fabric Administrator”

Authenticate issue, invalid_request,AADSTS9002327: Tokens issued for the 'Single-Page Application' client-type may only be redeemed via cross-origin requests.

  • No labels