Power BI

Work with the Power BI API

Actions20

Dataset Actions
Group Actions
Report Actions
Admin Actions
- Obter Informações de Workspaces
- Obter Resultado de Scan
Dashboard Actions

Overview

This node allows you to execute DAX queries on a specified Power BI dataset. It is useful when you want to retrieve data or perform calculations directly on your Power BI datasets using the Data Analysis Expressions (DAX) language. Typical scenarios include extracting filtered or aggregated data from large datasets, performing custom calculations, or integrating Power BI data into other workflows.

For example, you might use this node to run a DAX query that returns all distinct values from a table or calculates a measure dynamically, then use the results downstream in your automation.

Properties

Name	Meaning
Group (Workspace)	Power BI group (workspace) ID. Leave blank to use "My Workspace". Options are loaded dynamically.
Dataset	The ID of the dataset on which the DAX query will be executed. Options depend on the selected group.
DAX Query	The DAX query string to execute on the dataset. Example: `EVALUATE VALUES(MyMainTable)`

Output

The node outputs the result of the executed DAX query in the json field of the output items. This JSON contains the tabular data returned by the query, structured as rows and columns corresponding to the query result set.

No binary data output is produced by this operation.

Dependencies

Requires an API key credential for authenticating with the Power BI REST API.
The node interacts with the Power BI service endpoint at https://api.powerbi.com/v1.0/myorg.
Dynamic loading of groups (workspaces) and datasets depends on the authenticated user's access rights.

Troubleshooting

Common issues:
- Invalid or expired API credentials can cause authentication failures.
- Specifying a dataset or group ID that the user does not have access to will result in authorization errors.
- Malformed or invalid DAX queries will cause the API to return errors.
Error messages:
- "O recurso \"dataset\" não é suportado!" — indicates an unsupported resource was selected; ensure "Dataset" is chosen.
- Errors related to query execution typically come from the Power BI API and should be checked for syntax or permission issues.
Resolution tips:
- Verify API credentials and permissions.
- Confirm the dataset and workspace IDs are correct and accessible.
- Test DAX queries in Power BI Desktop or the Power BI service before using them in the node.