Content 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 Modified

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

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

Press Register.

Edit Authentication redirects

...

Api Permissions

Once created go to API Permissions and use “+Add a permission“(scroll down and click on View API permissions) 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

...

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

Enable service principal authentication for admin APIs

Enable service principal authentication for admin APIs - Microsoft Fabric | Microsoft Learn

...

Connect WIP to Power BI

In WIP create a new Power BI Server

...

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) 

...

• 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

Managed Fabric types

Microsoft Fabric API is evaluating quickly and new fabric types are added regularly.