Power BI Header Auth

Overview

This node enables interaction with the Power BI API using header-based authentication via a bearer token. Specifically, for the Dashboard - List operation, it retrieves a list of dashboards available in a specified Power BI workspace (group). This is useful when you want to automate or integrate Power BI dashboard management and retrieval within your workflows.

Common scenarios include:

• Fetching all dashboards from a particular workspace to display or process them further.
• Automating reporting pipelines by dynamically listing dashboards before performing other operations.
• Integrating Power BI dashboards metadata into other systems or databases.

Example: You have multiple workspaces in Power BI and want to list all dashboards in a specific workspace to generate reports or trigger alerts based on dashboard data.

Properties

Output

The node outputs an array of JSON objects representing dashboards retrieved from the Power BI API. Each object typically contains details about a dashboard such as its ID, display name, and other metadata provided by the API.

If the node supports binary data output (not indicated here), it would represent any associated files or images related to dashboards, but this operation primarily returns JSON data.

Dependencies

• Requires a valid Bearer authentication token for the Power BI API.
• The token must be provided either as input data or as a node parameter.
• No additional credentials or environment variables are explicitly required beyond the token.
• The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.

Troubleshooting

• Missing or invalid token error: If the token is not provided or invalid, the node throws an error indicating that the authentication token is mandatory. Ensure you provide a valid bearer token without the "Bearer" prefix.
• Token format issues: If the token string includes the "Bearer " prefix, it will be automatically trimmed. However, malformed tokens may cause authentication failures.
• Group ID not selected: If no group/workspace ID is provided, the node defaults to "My Workspace." If you intend to access other workspaces, ensure the correct group ID is set.
• API rate limits or permission errors: The token must have sufficient permissions to read dashboards in the specified workspace. Insufficient permissions will result in API errors.
• Network or connectivity issues: Ensure the node can reach the Power BI API endpoint and that there are no firewall restrictions.

Links and References

• Power BI REST API Documentation - Dashboards
• Power BI Authentication Overview
• n8n Documentation - Creating Custom Nodes