Power BI Header Auth

Overview

This node enables interaction with the Power BI API using header-based authentication. It is designed to perform various operations on Power BI resources such as groups (workspaces), dashboards, datasets, and reports by providing a bearer token for authorization.

For the Group - Get operation specifically, the node retrieves information about a specified Power BI group (workspace). This can be useful when you want to fetch details about a workspace to manage or analyze its contents programmatically.

Practical examples:

• Automating retrieval of workspace metadata to integrate with other reporting tools.
• Fetching group details before performing further operations like listing dashboards or reports within that workspace.
• Monitoring workspace properties in an automated workflow.

Properties

Output

The node outputs JSON data representing the details of the requested Power BI group. The structure typically includes metadata about the group such as its ID, name, description, and other relevant properties returned by the Power BI API.

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

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 parameter or via incoming data.
• The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
• No additional external services or environment variables are required beyond the authentication token.

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 a valid bearer token is provided without the "Bearer" prefix. Tokens can be passed directly or through previous nodes.

• Failed to load groups:
  Error message in dropdowns: "Erro ao carregar grupos. Verifique o token."
  Resolution: Verify the token's validity and permissions. The token must have sufficient rights to list groups.

• API errors during execution:
  If the API returns errors (e.g., unauthorized, forbidden), check that the token has appropriate scopes and that the group ID exists and is accessible.

• Input data issues:
  If the node expects token from input but none is provided, it will throw an error. Make sure input data contains the expected authentication token if not set in parameters.

Links and References

• Power BI REST API Documentation
• Power BI Groups API Reference
• OAuth 2.0 Authorization Framework (for understanding token generation and usage)