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 the refresh history of a specified dataset within a workspace (group). It is useful for monitoring and auditing dataset refreshes, helping users track when datasets were last updated and diagnose refresh issues.

Typical use cases include:

Automating reports on dataset refresh status.
Alerting teams if dataset refreshes fail or are delayed.
Integrating refresh history data into dashboards or other workflows.

For example, a user might configure this node to fetch the last 10 refresh events of a sales dataset in a specific workspace to ensure data freshness before running downstream analytics.

Properties

Name	Meaning
Group (Workspace)	Power BI group (workspace) ID. Leave blank to use "My Workspace". Options loaded dynamically.
Dataset	ID of the dataset to retrieve refresh history for. Options depend on selected group.
Limit	Maximum number of refresh history entries to return (corresponds to the `$top` parameter).

Output

The node outputs an array of JSON objects representing refresh history entries for the specified dataset. Each entry typically includes details such as:

Refresh start time
Refresh end time
Refresh status (e.g., Completed, Failed)
Refresh type (e.g., Manual, Scheduled)
Any error messages if the refresh failed

This structured output allows further processing, filtering, or alerting based on refresh outcomes.

The node does not output binary data.

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.
Dynamic loading of groups and datasets depends on API calls to Power BI to populate options.

Troubleshooting

Common Issues:
- Invalid or expired API credentials will cause authentication errors.
- Specifying a dataset or group ID that does not exist or is inaccessible will result in errors.
- If the dataset has no refresh history, the output may be empty.
Error Messages:
- Authentication failures: Check that the API key or token is valid and has sufficient permissions.
- Resource not found: Verify the group and dataset IDs are correct and accessible by the authenticated user.
- Rate limiting or API quota exceeded: Consider adding delays or reducing request frequency.