Power BI Header Auth

Overview

This node enables interaction with the Power BI API using header-based authentication. Specifically, for the Report resource and the Get Pages operation, it retrieves all pages of a specified Power BI report within a workspace (group). This is useful when you want to programmatically access the structure or metadata of a report's pages for automation, reporting, or integration purposes.

Common scenarios:

• Automating documentation or auditing of Power BI reports by extracting page details.
• Integrating report page information into other systems or workflows.
• Dynamically generating navigation or UI elements based on report pages.

Practical example:
You have a Power BI report in a workspace and want to list all its pages to create a custom dashboard navigation menu in another application. Using this node, you provide the workspace ID and report ID, authenticate via a bearer token, and retrieve the list of pages as JSON output.

Properties

Output

The node outputs a JSON array where each item represents a page of the specified Power BI report. Each page object typically contains metadata such as page name, display name, and possibly other page-specific properties returned by the Power BI API.

If the node supports binary data output (not indicated here), it would be summarized accordingly, but for this operation, the output is purely JSON describing report pages.

Dependencies

• Requires a valid Bearer token for Power BI API authentication. The token must be provided either as an input or directly in the node parameter.
• The token should have sufficient permissions to access the specified workspace and report.
• No additional external dependencies beyond the Power BI REST API.
• The base URL used for API requests is https://api.powerbi.com/v1.0/myorg.

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 data or in the node parameter.

• Invalid workspace or report ID:
  If the workspace (group) or report ID is incorrect or inaccessible, the API call will fail. 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 correctly without the prefix is recommended.

• API rate limits or permission errors:
  These errors come from the Power BI API. Check your API usage limits and token scopes/permissions.

Links and References

• Power BI REST API Documentation - Reports
• Power BI REST API - Get Report Pages
• Microsoft Identity Platform - OAuth 2.0 Authorization Code Flow