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 via a bearer token. Specifically, for the Group resource and Get Dashboards operation, it retrieves all dashboards available within a specified Power BI group (workspace). This is useful when you want to programmatically list or manage dashboards inside a particular workspace in Power BI.

Common scenarios include:

  • Automating reporting workflows by fetching dashboard metadata.
  • Integrating Power BI dashboards into other applications or services.
  • Monitoring or auditing dashboards across different workspaces.

Example: You provide an authentication token and select a Power BI group; the node returns a list of dashboards in that group, which can then be used downstream for further processing or analysis.

Properties

Name Meaning
Authentication Token Bearer token for authentication (without the "Bearer" prefix). Required to authorize API calls.
Group The Power BI group (workspace) from which to retrieve dashboards. Options are dynamically loaded based on the provided token.

Output

The node outputs JSON data representing the dashboards retrieved from the specified Power BI group. Each item in the output array corresponds to a dashboard object as returned by the Power BI API, typically including properties such as dashboard ID, display name, and other metadata.

No binary data output is produced by this operation.

Dependencies

  • Requires a valid Power BI API bearer token for authentication.
  • The token must have sufficient permissions to access the specified group's dashboards.
  • No additional external dependencies beyond the Power BI API.
  • The node expects the token either as an input field or as a parameter.
  • The base URL for API requests is https://api.powerbi.com/v1.0/myorg.

Troubleshooting

  • Missing or invalid token: If the token is not provided or invalid, the node will throw an error indicating that the authentication token is required or that loading groups/dashboards failed. Ensure the token is correct and has the necessary scopes.
  • Group not selected: If no group is selected, the node will prompt to select a workspace first.
  • API errors: Errors from the Power BI API (e.g., permission denied, rate limits) will be surfaced as node errors. Check the token permissions and API usage limits.
  • Token format: The node automatically strips the "Bearer " prefix if included; however, providing just the raw token string is recommended.

Links and References

Discussion