Power BI Header Auth icon

Power BI Header Auth

Work with the Power BI API using header authentication

Overview

This node enables interaction with the Power BI API using header-based authentication. Specifically, for the Report - Get operation, it retrieves detailed information about a specific Power BI report within a workspace (group). This is useful when you want to programmatically access metadata or details of reports hosted in Power BI, such as for reporting automation, auditing, or integration with other systems.

Practical examples include:

  • Fetching report details to display in a custom dashboard.
  • Automating report management workflows by retrieving report metadata.
  • Integrating Power BI report data into other business intelligence tools or processes.

Properties

Name Meaning
Authentication Token Bearer token for authenticating API requests (without the "Bearer" prefix).
Group (Workspace) Power BI group (workspace) ID where the report resides. Leave blank to use "My Workspace".
Report ID The unique identifier of the report to retrieve.

Output

The node outputs JSON data representing the retrieved report's details from the Power BI API. This typically includes metadata such as report name, ID, web URL, dataset ID, and other relevant properties describing the report.

If multiple input items are processed, the output will be an array of such JSON objects corresponding to each requested report.

The node does not output binary data.

Dependencies

  • Requires a valid Bearer token for Power BI API authentication. This token must be provided either as an input item property (access_token) or via the node parameter Authentication Token.
  • 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 calls is https://api.powerbi.com/v1.0/myorg.

Troubleshooting

  • Missing or invalid token: If no token is provided or the token is invalid, the node throws an error indicating that the authentication token is required or failed to authenticate.

    • Resolution: Ensure a valid bearer token is supplied without the "Bearer" prefix.
  • Invalid Group (Workspace) or Report ID: If the workspace or report ID is incorrect or inaccessible, the API call will fail.

    • Resolution: Verify the workspace and report IDs exist and the token has access rights.
  • Token format issues: If the token string starts with "Bearer ", the node automatically strips this prefix. However, malformed tokens may cause errors.

    • Resolution: Provide the raw token string without the "Bearer" prefix.
  • API rate limits or network issues: Standard Power BI API limitations apply.

    • Resolution: Check network connectivity and Power BI API usage quotas.

Links and References

Discussion