Power BI setup in minutes
Use Power BI with the Matatika platform in minutes.
Automate Power BI from a single space with no code
Trigger and monitor Power BI semantic-model refreshes as a step in a Meltano pipeline.
Connect with Microsoft (recommended)
-
Click Connect with Microsoft and consent with an account that has access to the target workspace — no Azure app registration required.
-
Capture the Workspace ID and Dataset ID from the Power BI URLs.
Service principal (unattended alternative)
For headless/scheduled use without an interactive login, configure a service principal instead (via API or meltano.yml):
-
Register an application in Azure Active Directory; capture Tenant ID, Client ID, Client Secret.
-
In Power BI Admin Portal → Tenant settings, enable "Service principals can use Power BI APIs" and add the principal (or a security group containing it).
-
Add the principal to each workspace whose datasets you intend to refresh.
Usage
Append powerbi:refresh to pipeline.actions after your load + transform steps. The command triggers a refresh and waits for completion by default; the pipeline fails if the refresh fails.
For troubleshooting: meltano invoke powerbi:status shows the most recent refresh; meltano invoke powerbi:history --top 10 lists recent runs.
Settings
Workspace ID
Power BI workspace (group) ID containing the dataset.
Dataset ID
Power BI dataset (semantic model) ID to refresh.
API URL
Power BI REST API base URL. Override for sovereign clouds (e.g. https://api.powerbigov.us/v1.0/myorg).
View source code
Power BI with your data warehouse
Use Power BI with your data warehouse or ours.
