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 Group resource and Get Reports operation, it retrieves reports available within a specified Power BI group (workspace). This is useful when you want to programmatically list or manage reports inside a particular workspace in Power BI.

Common scenarios include:

  • Automating report inventory across different workspaces.
  • Integrating Power BI report metadata into other systems or workflows.
  • Building dashboards or monitoring tools that reflect current reports in Power BI groups.

Example: You have multiple Power BI workspaces and want to fetch all reports from a specific workspace to display their names and IDs in another application.

Properties

Name Meaning
Authentication Token Bearer token for authenticating API requests (without the "Bearer" prefix). Required string.
Group The Power BI group (workspace) from which to retrieve reports. Selectable from available groups.

Output

The node outputs an array of JSON objects representing the reports retrieved from the specified Power BI group. Each object typically contains report metadata such as report ID, name, web URL, and other relevant details provided by the Power BI API.

If the node encounters errors during execution, the output may include error objects describing the issue per input item.

No binary data output is produced by this operation.

Dependencies

  • Requires a valid Bearer authentication token for the Power BI API with sufficient permissions to access the specified group and its reports.
  • The token can be provided either as an input field or via the node parameter.
  • The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
  • No additional external dependencies beyond standard HTTP requests.

Troubleshooting

  • Missing or invalid token: If the authentication token is missing or invalid, the node will throw an error indicating that the token is required or that authentication failed. Ensure the token is correct and has not expired.
  • Group not selected or inaccessible: If the group ID is not provided or the token does not grant access to the specified group, the node will return an error or empty results. Verify the group selection and token permissions.
  • API rate limits or network issues: Temporary failures contacting the Power BI API may cause errors. Retrying after some time or checking network connectivity can help.
  • Error messages: Errors are returned with descriptive messages, e.g., "Erro ao carregar relatórios. Verifique o token." means "Error loading reports. Check the token."

Links and References

Discussion