Power BI

Overview

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

Common scenarios include:

• Automating report inventory management across different workspaces.
• Integrating Power BI report metadata into other systems or dashboards.
• Triggering workflows based on available reports in a workspace.

Example: You might use this node to get all reports from a specific Power BI workspace to generate a summary report or to check which reports need updating.

Properties

Output

The node outputs an array of JSON objects, each representing a report within the specified Power BI group. Each object contains the report's metadata as returned by the Power BI API, such as report ID, name, web URL, and other relevant details.

If the node supports binary data output (not indicated here), it would typically represent report content or exported files, but in this case, the output is purely JSON metadata about reports.

Dependencies

• Requires a valid Power BI API authentication token configured in n8n credentials.
• Access to the Power BI service with permissions to read groups and reports.
• The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.

Troubleshooting

• Common issues:

  • Invalid or expired API credentials will cause authentication errors.
  • Insufficient permissions on the Power BI workspace may result in authorization errors.
  • Specifying a non-existent or inaccessible group ID will lead to empty results or errors.

• Error messages:

  • "The resource 'group' is not supported!" — indicates an unsupported resource was selected; ensure "Group" is chosen.
  • API errors returned from Power BI (e.g., 401 Unauthorized, 403 Forbidden) indicate credential or permission problems.

• Resolutions:

  • Verify and refresh your Power BI API credentials in n8n.
  • Confirm that the user associated with the credentials has access to the specified group.
  • Use the dynamic dropdown to select valid groups to avoid invalid IDs.

Links and References

• Power BI REST API Documentation
• Power BI Groups API Reference
• Power BI Reports API Reference