Actions20
- Dataset Actions
- Group Actions
- Report Actions
- Admin Actions
- Dashboard Actions
Overview
This node interacts with the Power BI API to retrieve datasets associated with a specified Power BI group (workspace). It is useful for scenarios where you want to programmatically access dataset information within a particular workspace, such as automating reporting workflows, integrating dataset metadata into other systems, or managing Power BI resources at scale.
For example, you might use this node to:
- Fetch all datasets in a specific Power BI workspace to audit or document them.
- Trigger downstream processes based on dataset properties or changes.
- Integrate dataset details into a data catalog or monitoring system.
Properties
| Name | Meaning |
|---|---|
| Group | The Power BI group (workspace) from which to retrieve datasets. Options are dynamically loaded from available groups in your Power BI environment. |
Output
The node outputs an array of JSON objects representing datasets retrieved from the specified Power BI group. Each object contains dataset details as returned by the Power BI API, such as dataset ID, name, and other metadata fields.
If the node supports binary data output (not indicated here), it would typically represent exported files or reports; however, for this operation, only JSON dataset information is returned.
Dependencies
- Requires a valid Power BI API authentication token configured in n8n credentials.
- Access to the Power BI service with permissions to read datasets in the specified group/workspace.
- The node uses the official Power BI REST API endpoint
https://api.powerbi.com/v1.0/myorg.
Troubleshooting
Common issues:
- Invalid or expired API credentials will cause authentication errors.
- Specifying a group ID that does not exist or to which the user lacks access will result in authorization errors.
- Network connectivity problems can prevent API calls from succeeding.
Error messages:
"The resource \"group\" is not supported!"— This indicates an unsupported resource was selected; ensure "Group" is chosen.- API error messages related to permissions or invalid group IDs should be resolved by verifying user access rights and correct group selection.
- If the node returns an error JSON object, check the message for details and adjust credentials or parameters accordingly.