Power BI Header Auth

Overview

This node enables interaction with the Power BI API using header-based authentication. Specifically, for the Dashboard resource and the Get Tiles operation, it retrieves the tiles (visual elements) of a specified Power BI dashboard within a workspace (group). This is useful when you want to programmatically access or analyze the individual components of a dashboard, such as charts, graphs, or other visuals.

Common scenarios:

• Automating reporting workflows by extracting dashboard tile data.
• Integrating Power BI dashboard visuals metadata into other systems.
• Monitoring or auditing dashboard contents across workspaces.

Practical example:
You have a Power BI dashboard in a specific workspace and want to list all its tiles to generate a custom report or trigger alerts based on tile content changes. Using this node, you provide the workspace ID and dashboard ID, authenticate via a bearer token, and retrieve detailed tile information.

Properties

Output

The node outputs an array of JSON objects representing the tiles of the specified dashboard. Each object corresponds to a tile and contains details such as tile ID, title, type, and possibly other metadata describing the visual element.

If the node supports binary data output (not indicated here), it would typically represent images or exported tile content, but this node focuses on JSON metadata about dashboard tiles.

Dependencies

• Requires a valid Bearer authentication token for the Power BI API. The token must be provided either as input data or as a node parameter.
• The node communicates with the Power BI REST API endpoint at https://api.powerbi.com/v1.0/myorg.
• No additional external dependencies are required beyond the Power BI API and proper authentication.

Troubleshooting

• Missing or invalid token:
  Error message: "Token de autenticação é obrigatório. Forneça um token na entrada ou no parâmetro do nó."
  Resolution: Ensure you provide a valid bearer token without the "Bearer" prefix either as input JSON (access_token) or in the node's Authentication Token parameter.

• Invalid workspace or dashboard ID:
  If the workspace (group) or dashboard ID is incorrect or missing, the API call will fail or return empty results. Verify IDs are correct and that the token has access rights.

• Token format issues:
  The node automatically strips the "Bearer " prefix if included. However, providing the token cleanly without the prefix avoids confusion.

• API rate limits or permissions:
  If the token lacks sufficient permissions or the API rate limit is exceeded, errors may occur. Check token scopes and Power BI service status.

Links and References

• Power BI REST API Documentation - Dashboards
• Power BI REST API - Get Tiles
• Microsoft Identity Platform - Access Tokens