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 Dataset resource with the List operation, it retrieves a list of datasets available in a specified Power BI group (workspace). This is useful when you want to programmatically access or manage datasets within your Power BI environment.
Common scenarios include:
- Automating reporting workflows by fetching dataset metadata.
- Integrating Power BI datasets into other systems or dashboards.
- Managing datasets across multiple workspaces without manual intervention.
For example, you might use this node to list all datasets in a particular workspace before triggering data refreshes or extracting schema information.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method used to authenticate with Power BI API. Options: OAuth2, Bearer Token |
| Group (Workspace) Name or ID | The Power BI group (workspace) identifier to list datasets from. Leave blank to use "My Workspace". You can select from a dropdown list or specify an ID via expression. |
Output
The node outputs an array of JSON objects representing datasets retrieved from the specified workspace. Each object typically contains dataset metadata such as dataset ID, name, and other relevant properties provided by the Power BI API.
If the node supports binary data output (not indicated here), it would represent dataset-related files or exports, but for the List operation on Dataset, the output is purely JSON metadata.
Dependencies
- Requires connection to the Power BI API.
- Supports two authentication methods:
- OAuth2 authentication flow.
- Bearer token (API key) authentication.
- Requires appropriate credentials configured in n8n for either method.
- Uses dynamic loading of groups (workspaces) for selection, which depends on successful API calls to fetch available groups.
Troubleshooting
- Authentication errors: Ensure that the OAuth2 credentials or bearer token are valid and have sufficient permissions to access the Power BI workspace and datasets.
- Empty results: If no datasets are returned, verify that the specified group ID or workspace is correct and contains datasets.
- API rate limits or permission issues: The Power BI API may restrict access based on user roles or API quotas; check your Power BI account permissions.
- Invalid group/workspace ID: Using an incorrect or non-existent group ID will result in errors or empty responses. Use the provided dropdown or confirm IDs via expressions carefully.
- Continue on Fail: If enabled, the node will continue processing subsequent items even if one fails, returning error details in the output.
Links and References
- Power BI REST API Documentation
- Power BI Datasets API Reference
- n8n Expressions Documentation (for using expressions in property fields)