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

Common scenarios include:

  • Automating reporting workflows by fetching dataset metadata.
  • Integrating Power BI datasets into other systems or dashboards.
  • Managing or auditing datasets across different workspaces.

Example: You have multiple Power BI workspaces and want to retrieve all datasets from a specific workspace to analyze their structure or usage.

Properties

Name Meaning
Authentication Token Bearer token for authentication (without the "Bearer" prefix). Required to authorize API calls.
Group Power BI group (workspace) from which to retrieve datasets. Selectable from available groups.

Output

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

If the node supports binary data output (not indicated here), it would represent dataset-related files or exports, but this operation focuses on JSON metadata.

Dependencies

  • Requires a valid Bearer authentication token for the Power BI API.
  • The token must be provided either as input data 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 services are required beyond Power BI API access.
  • Proper permissions/scopes on the token to read group datasets are necessary.

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 mandatory. Ensure the token is correct and has not expired.
  • Group not selected: If the group (workspace) is not selected or invalid, the node will fail to load datasets. Make sure to select a valid workspace.
  • API errors: Errors returned from the Power BI API (e.g., permission denied, rate limits) will propagate. Check token scopes and API quotas.
  • Token format: The token should be provided without the "Bearer " prefix; the node adds it automatically. Including the prefix may cause authentication failures.
  • Network issues: Connectivity problems to the Power BI API endpoint can cause request failures.

Links and References

Discussion