Sources
Power BI
Configuration
To set up the Power BI source and connect to your workspace, provide the following configuration parameters:
| Key | Description | Sample 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.