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 information about dashboards, specifically here focusing on the "Get Tiles" operation for a dashboard resource. It allows users to fetch all tiles (visual elements) present on a specified Power BI dashboard within a workspace (group). This is useful for automating reporting workflows, auditing dashboard contents, or integrating dashboard visuals into other applications.

Practical examples:

Automatically listing all tiles on a dashboard to generate documentation or reports.
Extracting tile metadata to synchronize with another BI tool or data catalog.
Triggering downstream processes based on the presence or configuration of specific tiles.

Properties

Name	Meaning
Group (Workspace)	Power BI group (workspace) ID. Leave blank to use "My Workspace". Options are dynamically loaded from available groups/workspaces.
Dashboard ID	The ID of the dashboard to retrieve tiles from. Options are dynamically loaded based on the selected group/workspace. This property is required.

Output

The node outputs an array of JSON objects representing the tiles on the specified dashboard. Each object corresponds to one tile and contains its metadata as returned by the Power BI API. Typical fields may include tile ID, title, type, embed URL, and other tile-specific properties.

If the node supports binary data output (not indicated in the provided code), it would typically represent embedded images or exported content related to tiles, but this is not evident here.

Dependencies

Requires a valid Power BI API authentication credential configured in n8n to authorize requests.
Relies on the Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
Dynamic loading of options for groups and dashboards depends on helper methods that query the Power BI API to list available workspaces and dashboards.

Troubleshooting

Common issues:
- Invalid or missing API credentials will cause authentication errors.
- Specifying a non-existent group or dashboard ID will result in API errors indicating resource not found.
- Network connectivity problems can cause request timeouts or failures.
Error messages:
- "O recurso \"dashboard\" não é suportado!" — means the requested resource is unsupported; ensure the resource and operation names are correct.
- API error messages returned in the JSON output if continueOnFail is enabled, otherwise they throw exceptions.
Resolutions:
- Verify API credentials and permissions.
- Confirm the group and dashboard IDs exist and are accessible by the authenticated user.
- Check network connectivity and Power BI service status.