Power BI

​
Configuration

To set up the Power BI source and connect to your workspace, provide the following configuration parameters:
KeyDescriptionSample Value
access_token(REQUIRED) Access token used to authenticate with your Power BI account.abcdefg123456
request_timeout(OPTIONAL) Timeout (in seconds) for API requests (default: 300).300
user_agent(OPTIONAL) User Agent string to send in the request header.my-app-v1.0
start_date(OPTIONAL) Filter results to only sync records updated after this date. Format: YYYY-MM-DD.2023-01-01

​
What is Power BI?

Power BI is Microsoft’s leading business intelligence (BI) platform, enabling organizations to visualize data, create interactive dashboards, and generate real-time insights.
Integrating Power BI with Mage allows you to automate data extraction, sync analytics reports, and merge insights across your enterprise data ecosystem.

​
How to Get Your access_token

Follow Power BI’s official instructions to generate an OAuth access_token via the Azure Active Directory (Azure AD) app registration process.

​
Why Integrate Power BI with Mage?

  • Automate report extraction: Fetch dashboards, reports, and datasets seamlessly.
  • Centralize business analytics: Combine Power BI data with data warehouses and lakes.
  • Real-time decision-making: Access up-to-date analytics without manual refreshes.
  • Enhanced scalability: Manage large-scale BI deployments with streamlined data syncs.
  • Boost productivity: Eliminate manual export processes for business users and analysts.

​
Supported Streams from Power BI

When integrated with Mage, Power BI enables access to the following data streams:
  • apps — Metadata about published Power BI apps in your organization.
  • dashboards — Details of dashboards created and shared within workspaces.
  • datasets — Information about datasets, including refresh schedules and models.
  • groups — Workspaces and group information for collaborative projects.
  • reports — Metadata on reports built and published in Power BI.
  • tiles — Tiles on dashboards representing visuals and pinned content.