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 interacts with the Power BI API to retrieve detailed information about datasets within a specified workspace (group). The "Get" operation for the "Dataset" resource fetches metadata and properties of a particular dataset identified by its ID. This is useful when you want to programmatically access dataset details such as schema, refresh status, or other metadata for reporting, automation, or integration purposes.

Practical examples:

Automatically retrieving dataset details to monitor dataset configurations.
Integrating dataset metadata into dashboards or reports outside Power BI.
Using dataset info in workflows that trigger actions based on dataset properties.

Properties

Name	Meaning
Group (Workspace)	Power BI group (workspace) ID. Choose from available workspaces or leave blank to use "My Workspace".
Dataset	ID of the dataset to be retrieved. Select from datasets available in the chosen workspace.

Output

The node outputs an array of JSON objects representing the dataset's metadata and properties as returned by the Power BI API. Each item corresponds to one dataset's detailed information, including fields such as dataset name, ID, tables, relationships, and other relevant metadata.

No binary data output is produced by this operation.

Dependencies

Requires a valid Power BI API authentication token configured in n8n credentials.
The node depends on the Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
The user must have appropriate permissions to access the specified workspace and dataset.

Troubleshooting

Common issues:
- Invalid or missing workspace (group) ID may cause the node to fail to find datasets.
- Incorrect dataset ID will result in errors indicating the dataset was not found.
- Insufficient permissions on the Power BI service can lead to authorization errors.
- Network connectivity issues can prevent API calls from succeeding.
Error messages and resolutions:
- "The resource 'dataset' is not supported!" — Ensure the resource and operation are correctly set.
- "Dataset not found" or similar — Verify the dataset ID and workspace ID are correct.
- Authorization errors — Check that the API key credential has sufficient rights and is valid.
- Timeout or network errors — Confirm network connectivity and Power BI service availability.