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.
Prerequisites
-
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.
-
Capture the Workspace ID and Dataset ID from the Power BI URLs.
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
Tenant ID
Azure AD tenant ID.
Client ID
Azure AD application (client) ID.
Client Secret
Azure AD application client secret.
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.
