Power BI

  • Updated on Oct 16, 2025
  • Published on Oct 13, 2025
  • 2 minute(s) read
Prev Next

Introduction

These types of datasources represent a connection to Power BI.

For some examples, see
- How to configure a PowerBI Datasource in version 3.6 and higher?
- How to create a Word report using PowerBI as a data source in Mail & Deploy (with example)?
- How to create an Excel report using PowerBI as a data source in Mail & Deploy (with example)?
- How to create a Task using a PowerBI Supporting Report (with example)?

Properties

Power BI Datasources have the following properties.

Name

 Description
Authentication Type The method to use to authenticate.

This can be either 'Azure Service Principal' or 'Connection String'.

Depending on the choice of the above you will be able to set the following properties.

Azure Service Principal

If you select 'Azure Service Principal' for 'Authentication Type' you will have the following properties:

Name

 Description
Tenant ID The tenant ID of the Azure Service Principal.
Client ID The client ID of Azure Service Principal.
Client Secret The client secret of Azure Service Principal.
Catalog This is the combination of the Power BI workspace and semantic model. The list of these are generated automatically.

You will need to create an app registration in your Azure portal to support this.

  • Logon to your Azure portal.
  • Click App registrations.
  • Add a new registration.
  • In the App Overview, note the Application ID and Directory ID. These will be the Client ID and Tenant ID above.
  • Click Certificates & secrets.
  • Click New client secret, create the new secret. This will be the Client Secret above.

You will also need to give this Azure App access to your workspace. To do this:

  • Log into Power BI.
  • Find the Workspace you want to grant access to.
  • Click 'Manage access'.
  • Click '+ Add people or groups', find the name of the app previously created and it add as a Member.

Additionally, in the Microsoft Fabric > Admin Portal > Tenant settings > Developer settings

  • Enable the option Service principal can call Fabric public APIs.

Connection String

If you select 'Connection String' for 'Authentication Type' you can enter a connection string with the following format:

key1=value1;key2=value2; key3=value3...
Name Required Value
AuthScheme Yes Must be set to 'AzureServicePrincipal'. See notes above about creating this.
AzureTenant Yes See notes above about creating this (Tenant ID).
OAuthClientId Yes See notes above about creating this (Client ID).
OAuthClientSecret Yes See notes above about creating this (Client Secret).
Workspace Yes The name of the workspace containing the dataset.
Dataset Yes The name of the dataset / semantic model.

Here is an example:

AuthScheme=AzureServicePrincipal; AzureTenant={TENANT ID}; OAuthClientId={CLIENT ID}; OAuthClientSecret={CLIENT SECRET}; Workspace={WORKSPACE NAME}; Dataset={SEMANTIC MODEL NAME}