WIP Connect to Power BI

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

Open

• Go to your Microsoft Azure console / Entra ID / App Registrations

• + New registration

• Open

  

   

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

• Redirect Url : Web + 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

• 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:

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

Assign Service Principal to Workspaces in Admin Portal

Add service principal to fabric administrative group

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

Fill the WIP Power BI server fields client and tenant ID according to the information in the overview section of your application.

For the Secret key, generate a client secret and copy the value to Secret key

Then press the test power bi server button to check if the configuration is correct.

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.

• In platform configuration ensure you have a web application and one redirect to WIP url not a single page application…

Install WIP Desktop app for Power BI

You can install WIP desktop application that will help to check in and out Power BI application to your local machine and edit them in Power BI Desktop

1. Download WIP Desktop from ebiexperts support download section WIP Desktop for Power BI, WIP Addons for SAP and QlikView

2. Launch the installer

At this stage you need to configure the WIP Desktop to connect the WIP Web Server, go to the installation location C:\Program Files\ebiexperts WIP Desktop by default,

edit the “appsettings.Production.json” file,

• AzureAd.TenantID : the tenant ID from the azure application registration

• AzureAd.ClientId : the client ID from the azure application registration

• WipApiUrl : the wip server url

• WipLoginEnvironmentId : the wip login environment id,