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.

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, search "admin api" in the search box.

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

   

   

   

4. This configuration could take 15-25 mins

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]