Power BI

Overview

This node interacts with the Power BI API to retrieve information about various Power BI resources. Specifically, for the Group resource and the Get Dashboards operation, it fetches dashboards that belong to a specified Power BI group (workspace). This is useful when you want to programmatically list or manage dashboards within a particular workspace in Power BI.

Common scenarios:

• Automating reporting workflows by retrieving dashboard metadata from a specific workspace.
• Integrating Power BI dashboards into other systems or portals by fetching their details dynamically.
• Auditing or monitoring dashboards across different workspaces.

Practical example:
You have multiple Power BI workspaces for different departments. Using this node, you can select a workspace and get all dashboards inside it, then use that data to generate reports or trigger notifications if certain dashboards are updated.

Properties

Output

The node outputs an array of JSON objects, each representing a dashboard retrieved from the specified Power BI group. Each object contains the dashboard's metadata as returned by the Power BI API, such as its ID, name, and other relevant properties.

If the node supports binary data output (not indicated here), it would typically represent exported dashboard content or images, but for this operation, only JSON metadata is returned.

Dependencies

• Requires a valid Power BI API authentication credential configured in n8n to authorize requests.
• The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
• Dynamic loading of groups (workspaces) depends on the API access to list groups.

Troubleshooting

• Common issues:

  • Invalid or missing API credentials: Ensure your Power BI API key or OAuth token is correctly set up in n8n.
  • Insufficient permissions: The authenticated user must have access rights to the selected Power BI group/workspace.
  • Empty results: If no dashboards are returned, verify that the selected group actually contains dashboards.
  • API rate limits: Frequent calls may hit Power BI API limits; consider adding delays or error handling.

• Error messages:

  • "The resource \"group\" is not supported!" — This indicates an unsupported resource was selected; ensure "Group" is chosen.
  • Errors related to network or authorization will be passed through; check your credentials and network connectivity.
  • If the node fails but "Continue On Fail" is enabled, errors will be included in the output JSON under an error field.

Links and References

• Power BI REST API Documentation
• Power BI Groups (Workspaces) API
• Power BI Dashboards API