Skip to main content
Microsoft Power BI is a business analytics platform for building interactive reports and dashboards on top of governed semantic models. With BonData, you can connect to your Power BI tenant to read workspace metadata and query dataset rows within Agent workflows.

​
Power BI Azure AD OAuth 2.0 Setup

Follow these steps to register an app in Microsoft Entra ID (Azure AD) and authorize it against the Power BI REST API.

​
Step 1: Register an App in Entra ID

  1. Go to the Azure Portal and open Microsoft Entra ID (formerly Azure Active Directory)
  2. Navigate to App registrations → New registration
  3. Configure:
    • Name: BonData Integration
    • Supported account types: Accounts in this organizational directory only
    • Redirect URI: Web - https://app.bondata.ai/auth/oauth2/callback
  4. Click Register
  5. On the Overview page, copy the Application (client) ID and Directory (tenant) ID

​
Step 2: Grant Power BI Service API Permissions

  1. Go to API permissions → Add a permission
  2. Select Power BI Service
  3. Choose Delegated permissions and add Tenant.Read.All, Dataset.Read.All, Report.Read.All, and Workspace.Read.All
  4. Click Add permissions, then Grant admin consent (requires a tenant administrator)
To read dataset table rows over the XMLA endpoint, an administrator must enable XMLA endpoint read access in the Power BI Admin portal under Tenant settings → Integration settings. This requires a Premium or Fabric capacity.

​
Step 3: Create a Client Secret

  1. Go to Certificates & secrets → Client secrets
  2. Click New client secret, add a description, and select an expiration
  3. Copy the secret value immediately - it is only shown once

​
Step 4: Enter Credentials in BonData

  1. In BonData, navigate to Integrations and select Power BI
  2. Enter your Tenant ID, Client ID, and Client Secret
  3. Click Connect

​
Required Fields

​
Available Data

Once connected, BonData can sync the following Power BI data via the Power BI REST API and XMLA endpoint:
  • Workspaces - Workspace (group) metadata including capacity assignment and access
  • Datasets - Semantic models with configured tables, refresh schedules, and data sources
  • Reports - Report definitions and their associated datasets
  • Dashboards - Dashboards and their pinned tiles
  • Dataflows - Dataflow definitions and entity metadata
  • Dataset Table Rows - Row-level data queried from dataset tables via the XMLA endpoint