Power BI icon

Power BI

Work with the Power BI API

Overview

This node integrates with the Power BI API to perform various operations on Power BI resources. Specifically, for the Group resource and the Get Dashboards operation, it retrieves dashboards associated with a specified Power BI group (workspace). This is useful when you want to programmatically access dashboard metadata or list dashboards within a workspace for reporting, automation, or monitoring purposes.

Common scenarios:

  • Automating the retrieval of all dashboards in a specific Power BI workspace.
  • Integrating Power BI dashboard data into other workflows or systems.
  • Monitoring changes or updates to dashboards within a group.

Example:
You have multiple Power BI workspaces and want to generate a report listing all dashboards available in each workspace. Using this node, you can select a workspace and fetch its dashboards automatically.

Properties

Name Meaning
Authentication Method used to authenticate with Power BI API. Options: OAuth2, Bearer Token
Group Name or ID The Power BI group (workspace) from which to retrieve dashboards. Choose from a list or specify an ID using an expression

Output

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

If the node supports binary data output (not explicitly shown here), it would represent any binary content related to dashboards, but for this operation, the output is primarily JSON metadata.

Dependencies

  • Requires valid authentication credentials for Power BI API access, either via OAuth2 or a Bearer Token.
  • The node depends on internal helper functions to load groups and dashboards dynamically.
  • No additional external dependencies beyond the Power BI API and n8n's credential management.

Troubleshooting

  • Common issues:

    • Invalid or expired authentication tokens will cause API calls to fail.
    • Specifying a non-existent or inaccessible group ID will result in errors or empty results.
    • Network connectivity issues may prevent successful API communication.
  • 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., unauthorized, forbidden) usually relate to authentication or permission issues.
  • Resolutions:

    • Verify that the authentication credentials are correct and have sufficient permissions.
    • Confirm the group ID or name exists and is accessible by the authenticated user.
    • Check network connectivity and retry if transient errors occur.

Links and References

Discussion