Power BI

Overview

This node integrates with the Power BI API to interact with various Power BI resources such as dashboards, reports, datasets, groups (workspaces), and admin features. Specifically, for the Dashboard - List operation, it retrieves a list of dashboards available in a specified Power BI group (workspace). This is useful when you want to programmatically access or manage dashboards within your Power BI environment.

Common scenarios:

• Automating reporting workflows by fetching dashboard metadata.
• Integrating Power BI dashboards into other applications or services.
• Monitoring or auditing dashboards across different workspaces.
• Dynamically listing dashboards to allow users to select one for further operations.

Example use case:
You have multiple Power BI workspaces and want to generate a report that lists all dashboards in a particular workspace. Using this node, you can specify the workspace ID and retrieve all dashboards within it, then process or export that data as needed.

Properties

Output

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

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

Dependencies

• Requires a valid Power BI API authentication credential configured in n8n (an API key or OAuth token).
• The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
• Dynamic loading of workspace options depends on the ability to query Power BI groups via the API.

Troubleshooting

• Common issues:

  • Invalid or missing API credentials will cause authentication errors.
  • Specifying a non-existent or unauthorized workspace ID will result in permission or not found errors.
  • Network connectivity problems may prevent API calls from succeeding.

• Error messages:

  • "The resource \"dashboard\" is not supported!" — indicates an unsupported resource was selected; ensure "Dashboard" is chosen.
  • API error messages returned from Power BI (e.g., 401 Unauthorized, 404 Not Found) should be checked for correct credentials and workspace IDs.

• Resolutions:

  • Verify that the API credential has sufficient permissions to access the requested workspace.
  • Confirm the workspace ID is correct and accessible by the authenticated user.
  • Check network settings and proxy configurations if requests fail to reach the Power BI API.

Links and References

• Power BI REST API Documentation
• Power BI Dashboards API Reference
• n8n Documentation on Credentials