Power BI icon

Power BI

Work with the Power BI API

Overview

This node interacts with the Power BI API to retrieve information about Power BI groups (workspaces). Specifically, the "Get" operation under the "Group" resource fetches details of a selected Power BI group. This is useful for workflows that need to access metadata or properties of specific workspaces within an organization's Power BI environment.

Practical examples include:

  • Automating reports or dashboards generation by first retrieving workspace details.
  • Integrating workspace information into other systems for auditing or monitoring.
  • Triggering downstream processes based on workspace attributes.

Properties

Name Meaning
Group The Power BI group (workspace) to retrieve information from. Options are dynamically loaded from available groups in the connected Power BI account.

Output

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

No binary data output is indicated for this operation.

Dependencies

  • Requires a valid Power BI API authentication credential configured in n8n.
  • The node uses the official Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
  • Dynamic loading of group options depends on successful API calls to list available groups.

Troubleshooting

  • Common issues:

    • Authentication failures due to invalid or expired API credentials.
    • No groups returned if the authenticated user has no access to any Power BI workspaces.
    • Network or API rate limiting errors from Power BI service.
  • Error messages:

    • "O recurso "<resource>" não é suportado!" — indicates an unsupported resource was selected; ensure "Group" resource is chosen.
    • Errors related to missing or invalid group selection; verify that a valid group is selected.
    • API errors will be returned in the output JSON under an error field if "Continue On Fail" is enabled.
  • Resolutions:

    • Verify and refresh API credentials.
    • Confirm user permissions in Power BI for accessing groups.
    • Check network connectivity and retry after some time if rate limited.

Links and References

Discussion