Introduction
In this article, we’ll walk you through the process of linking Power BI to Introw using a Service Principal. By the end of the steps, you’ll have your Tenant ID, Client ID, and Secret Key which are required to establish a secure connection between Power BI and Introw.
Step 1: Register an application in Azure
Azure applications are the credentials that allow us to cross certain bridges, or rather, communicate with different services within the Microsoft cloud. To register a new app, go to the Azure Portal ( https://www.portal.azure.com ).
Within the Entra ID service (previously called Active Directory) you can find a Registered Applications menu where you can put “New Registration”. Just use the default settings. When completed you will be able to retrieve the Tenant ID and the Client ID.
For example: Introw Power BI
Step 2: Add the new created app to a Security group
Add the newly created application to a security group or create a new security group and add the newly created application.
Step 3: Configure the API permissions of the application
Configure the API permissions for your newly created application. This grants the Introw power BI application to read the required data from Power BI.
The required permissions are:
Dashboard.Read.All
Dataset.Read.All
Report.Read.All
Workspace.Read.All
Step 4: Generate a Secret Key
Generate a secret key for the newly created Service Principal Application.
Step 5: Configure the tenant settings
To ensure that our application, registered with a secret (service principal), can use the API services, we need to allow it from the administration portal. As an administrator from Fabric/PowerBI, we open the administration portal from the menu that reveals the configuration gear. Enable the Service principals can call Fabric public APIs setting and apply for the security group where the registered Introw Power Bi application is member of.
Step 6: Manage workspace access
The application also needs access to the Power BI workspace that will be used to embed reports and dashboards in Introw. To grant this access, navigate to the relevant workspace, open Manage Access, and add the security group.
Step 7: Link Introw to Power BI
Enter the required credentials in Introw and finalize the connection with Power BI.
Introw will not store any Client Secret, this is only needed one-time to establish the connection to Power BI.