Page Comparison

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

...

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

• + New registration

...

• Image Added

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

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

...

In WIP create a new Power BI Server

Image Added

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

Image Added

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 “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 ebiexpertssupport download section WIP Desktop for Power BI, WIP Addons for SAP and QlikView

2. Launch the installer

Image Added

Image Added

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": "4bdd06f5-b479-4330-8b6d-3d5e3d4689c4",
    "ClientId": "72195396-b37b-4783-91bb-e9845f6ad6e5"
  },
  "WipApiUrl": "https://localhost:59279/",
  "WipLoginEnvironmentId": "310",
  "Serilog": {
    "MinimumLevel": {
      "Default": "Verbose",
      "Override": {
        "Microsoft": "Verbose",
        "System": "Verbose"
      }
    }
  }
}

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

Image Added