Actions32
- Admin Actions
- Dashboard Actions
- Dataflow Actions
- Dataset Actions
- Gateway Actions
- Group Actions
- Report Actions
Overview
This node integrates with the Power BI API to perform various operations on Power BI resources. Specifically, for the Group resource and the Get Datasets operation, it retrieves datasets associated with a specified Power BI group (workspace). This is useful when you want to programmatically access or manage datasets within a particular workspace in Power BI.
Common scenarios include:
- Automating reporting workflows by fetching dataset metadata from a workspace.
- Integrating Power BI datasets into other systems or dashboards.
- Monitoring or auditing datasets available in specific Power BI groups.
Example: You might use this node to get all datasets from a marketing team's Power BI workspace to analyze which datasets are actively used or need updating.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating with Power BI API. Options: OAuth2 or Bearer Token (API key). |
| Group Name or ID | The Power BI group (workspace) from which to retrieve datasets. Choose from a list or specify an ID. |
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.
If the node supports binary data output (not indicated here), it would typically represent files or reports, but for this operation, the output is purely JSON data describing datasets.
Dependencies
- Requires connection to the Power BI API.
- Supports two authentication methods: OAuth2 and Bearer Token (API key).
- The user must configure appropriate credentials in n8n for authentication.
- Uses internal helper functions to load options dynamically (e.g., listing groups).
Troubleshooting
Common issues:
- Invalid or expired authentication tokens can cause authorization errors.
- Specifying a non-existent group ID will result in no datasets found or an error.
- Network connectivity issues may prevent API calls.
Error messages:
"The resource "group" is not supported!"— indicates an unsupported resource was selected; ensure "Group" is chosen.- API errors related to authentication failure suggest checking credentials.
- If the node fails but "Continue On Fail" is enabled, errors will be returned as part of the output JSON.
Links and References
- Power BI REST API Documentation
- n8n Expressions Documentation (for specifying dynamic group IDs)