Power BI icon

Power BI

Work with the Power BI API

Actions20

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) or in the default "My Workspace" if no group is specified.

This functionality is useful when you want to programmatically access and manage datasets within your Power BI environment. For example, you might use this node to:

  • Enumerate all datasets in a workspace before performing further actions like refreshing or querying them.
  • Automate reporting workflows by dynamically discovering datasets.
  • Integrate dataset metadata into other systems or dashboards.

Properties

Name Meaning
Group (Workspace) Power BI group (workspace) ID. Selects the workspace from which to list datasets. Leave blank to use the default "My Workspace". Options are dynamically loaded from available groups.

Output

The node outputs an array of JSON objects representing datasets retrieved from the Power BI API. Each object typically contains dataset metadata such as dataset ID, name, and other relevant properties provided by the API.

The output structure corresponds directly to the dataset list response from Power BI, enabling downstream nodes to process dataset details, filter them, or trigger further operations like refresh or query execution.

No binary data output is produced by this operation.

Dependencies

  • Requires a valid Power BI API authentication credential configured in n8n.
  • The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
  • The user must have appropriate permissions to access the specified workspace and its datasets.

Troubleshooting

  • Common issues:

    • Invalid or missing API credentials will cause authentication failures.
    • Specifying a non-existent or unauthorized group ID will result in errors or empty results.
    • Network connectivity problems can prevent API calls from succeeding.

  • Error messages:

    • "The resource \"dataset\" is not supported!" — This indicates an unsupported resource was selected; ensure "Dataset" is chosen.
    • API error messages returned from Power BI (e.g., permission denied, invalid group ID) will be surfaced in the node's output if "Continue On Fail" is enabled.

  • Resolutions:

    • Verify that the API key or OAuth token used has sufficient permissions.
    • Confirm the group ID exists and the authenticated user has access.
    • Check network settings and proxy configurations if applicable.

Links and References

Discussion