PowerBI Connector Setup

This guide will walk you through how to set up PowerBI Connector in Datalogz via service principal. This method allows read-only access to PowerBI's administrative APIs for a single PowerBI tenant.

Time estimated: 6 mins

To start, we need the following:

1. Azure App registration → https://portal.azure.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

2. Azure Group creation → https://portal.azure.com/#view/Microsoft_AAD_IAM/GroupsManagementMenuBlade/~/Overview

3. PowerBI configuration → https://app.powerbi.com/admin-portal/tenantSettings

4. Datalogz account & license activation -> contact [e-mail]

5. Log in to your Datalogz account → https://app.datalogz.io/#/organization/connectors

Step 1: Create a new App Registration

1. Open App registrations link -> https://portal.azure.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

2. Create New Registration

   
3. Create a name for your app, select single tenant (first option) as a supported account type, ignore the optional field as needed, and click Register at the bottom.

   

In this new app, we will need three pieces of information

1. Application (client) ID & Directory (tenant) ID

Application (client)ID & Directory (tenant) ID

Before continuing, please ensure you save all critical information (e.g., credentials, API keys, or configuration details) to a secure notepad or document for easy reference.

✅ Recommended Action: Copy and paste the information into your favorite text editor (e.g., Notepad, Notion, or Google Docs).

1. Client Secret Value

   1. Under Manage in the side nav

   2. Click Certificates & secrets & create new

   3. Find the Client Secret Value

The Client Secret Value will only be shown once during creation. If you refresh or navigate away, you won’t be able to view it again.

✅ Recommended Action: Copy and paste the client secret into your secure note-taking tool (e.g., Notepad, Notion, or a password manager) as soon as it's generated. If lost: You’ll need to generate a new client secret.

Grant Permissions for the new App Registration Here add permissions specifically for the Power

• Tenant.ReadWrite.All

• Dataset.ReadWrite.All

Step 2: Create a new Group in Azure

1. Click and open Azure Group link https://portal.azure.com/#view/Microsoft_AAD_IAM/GroupsManagementMenuBlade/~/Overview

2. Create a new group

   

   
3. Add members by adding the new app to the Enterprise applications

   
4. Create new group

Step 3: Configure PowerBI with the Group

1. Open PowerBI Tenant Settings: https://app.powerbi.com/admin-portal/tenantSettings

2. In the Admin Portal's keyword search box type "XMLA", and in the Integration settings section enable "Allow XMLA endpoints and Analyze in Excel with on-premises semantic models"

   

   If not enabled for the entire organization add the Security Group that the Datalogz's service principal is a member of.
3. In the Admin Portal's keyword search box type "fabric api" and enable "Service Princepals can use Fabric APIs"

   
4. In the Admin Portal's keyword search box type "admin api".

   
5. Enable all three Admin API settings and apply all newly created Groups.

   1. 

      Enable: Service principals can access read-only admin APIs Enabled.
   2. 

      Enhance admin APIs responses with detailed metadata Enabled.
   3. 

      Enhance admin APIs responses with DAX and mashup expressions Enabled.
6. Note: This configuration can take 15-25 mins for changes to work its way through PowerBI.

Important: License Activation Required

Before logging into your account, please ensure your license file is activated. Without activation, access to your account may be restricted.

Contact the Datalogz Team:

• Send a request to activate your license file to [e-mail]

• Provide any relevant information (e.g., company name, user email) to speed up the process.

Step 4: Create a New Connector in Datalogz

1. Log in to your Datalogz account

2. Navigate to Connector in the sidebar, and click New Connector

   
3. Choose PowerBI, and select Connect using a Service Principal (SP)

   
4. Copy-paste the new application information.

   1. Directory (tenant) ID

   2. Application (client) ID

   3. Client Secret Value

   

Step 5: Reload the connection in Datalogz

1. Select a PowerBI workspace

   

2. Reload Workspace and select all, option to expand and choose personal workspace

   

   

3. Rename Connection and Continue to Next Step.

   

4. Schedule the Connector Refresh rate.

   

5. Refresh and click to view the new connector.

   

For more questions, please contact Datalogz support [e-mail]

Capacity Monitoring (Additional Setup)

1. Navigate to the Admin Portal and enable the Integration Setting for Semantic Model Execute Queries REST API. When enabled, users in the organization can query semantic models by using Data Analysis Expressions (DAX) through Power BI REST APIs.

   
2. The full documentation for the "Microsoft Fabric Capacity App" can be found in Microsoft's Doc pages. While you can use an existing Fabric Capacity Metrics app setup in PowerBI it's suggested to get the app again and setup a workspace specifically for use with Datalogz.

   

   1. Install the Microsoft Fabric Capacity App in your Power BI environment. Navigate to the "Apps" section on the side bar of Power BI. There you can search for the "Microsoft Fabric Capacity App" and add it.

   2. Navigate to the "Microsoft Fabric Capacity Metrics" Workspace that is created with the app. Go to Manage Access and grant "Admin" permissions to the Datalogz service principal Groups.

   3. Run the app for the first time to start data flowing into the semantic model.

3. Provide the Dataset ID for the "Fabric Capacity Metrics" to Datalogz. This can be found in the URL when viewing the semantic model in your web browser.

   1. Sample :