Skip to main content

Link Introw to Power BI

Learn how to link Introw to you Power Bi and setup the right Authentication

Wouter Moyaert avatar
Written by Wouter Moyaert
Updated over 2 weeks ago

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.

You are all set!

Did this answer your question?