Power BI Configuration

This section explains how to configure a Power BI connection in AskSenseOps using an Azure AD app registration and Power BI API permissions.

Prerequisites

Before configuring the connection, ensure that you have:

• Access to Microsoft Azure and the appropriate permissions to register an application.
• An Azure AD app registration with the required Power BI API permissions.
• The Tenant ID, Client ID, and Client Secret for the registered application.
• Admin consent granted for the required API permissions.
• The application added as a member of the Power BI workspace you want to access, if you specify a workspace.

For guidance on registering an application, refer to the Microsoft documentation on app registration.

Adding a Power BI Connection

1. Open AskSenseOps.
2. Navigate to Admin and select Connections under Data.
3. Click Add connection.
4. Set Platform Type to Power BI.
5. Enter the connection details described below.
6. Test the connection and save it.

Connection Details

Basic Info

Field	Description	Required
Connection Name	Enter a name to identify the connection, such as Production Server.	Yes
Description	Enter optional notes about the connection.	No

Azure AD Configuration

Field	Description	Required
Tenant ID	Enter the Tenant ID of your Azure AD tenant.	Yes
Client ID	Enter the Application (Client) ID of your registered Azure AD application.	Yes
Client Secret	Enter the client secret associated with the application.	Yes

Required API Permissions

The registered application must have the following Power BI Service API permissions:

• Dataset.Read.All
• Workspace.Read.All

After adding these permissions, grant admin consent.

Workspace

Field	Description	Required
Workspace ID	Enter a specific Power BI workspace ID if you want to configure a particular workspace.	No

Leave Workspace ID empty to automatically list all workspaces accessible to the service principal.

If you specify a workspace, ensure that the application has been added as a member in the workspace's Access settings.

Testing and Saving the Connection

After entering the required details:

1. Review the Tenant ID, Client ID, and Client Secret.
2. Confirm that the required Power BI API permissions have been added and admin consent has been granted.
3. Click Test Connection to verify the connection.
4. If the test succeeds, click Save Connection to save the configuration.

If the connection test fails, verify the application credentials, API permissions, admin consent, and workspace access settings.