Power BI icon

Power BI

Work with the Power BI API

Actions32

Overview

This node integrates with the Power BI API to perform various operations on Power BI resources. Specifically, for the Dashboard resource with the List operation, it retrieves a list of dashboards available in a specified Power BI workspace (group). This is useful when you want to automate reporting workflows, monitor dashboard availability, or dynamically fetch dashboard metadata for further processing.

Practical examples:

  • Automatically listing all dashboards in a team’s Power BI workspace to generate reports or notifications.
  • Fetching dashboard IDs and names to use as inputs for other Power BI operations like exporting or embedding.
  • Integrating Power BI dashboard data into other systems or workflows without manual intervention.

Properties

Name Meaning
Authentication Method used to authenticate with Power BI API. Options: OAuth2, Bearer Token.
Group (Workspace) Name or ID The Power BI group (workspace) identifier. Leave blank to use the default "My Workspace". You can select from a list or specify an ID using an expression.

Output

The node outputs a JSON array where each item represents a dashboard retrieved from the specified workspace. Each dashboard object typically contains properties such as dashboard ID, name, and possibly other metadata depending on the API response.

If the node supports binary data output (not explicitly shown here), it would represent dashboard-related files or exports; however, this operation primarily returns JSON metadata about dashboards.

Dependencies

  • Requires access to the Power BI API.
  • Needs either OAuth2 credentials or a Bearer Token for authentication.
  • The node uses internal helper methods to load available groups (workspaces) and dashboards.
  • Proper configuration of credentials in n8n is necessary to authenticate requests.

Troubleshooting

  • Common issues:

    • Invalid or expired authentication tokens will cause authorization errors.
    • Specifying an incorrect or inaccessible group/workspace ID may result in empty results or errors.
    • Network connectivity issues can prevent API calls from succeeding.

  • Error messages:

    • "The resource "dashboard" is not supported!" — indicates a misconfiguration or unsupported resource selection.
    • Authorization errors usually mention invalid credentials or lack of permissions; ensure the API key or OAuth token has sufficient rights.
    • If the node fails but "Continue On Fail" is enabled, error details are returned per item instead of stopping execution.

  • Resolutions:

    • Verify and refresh authentication credentials.
    • Confirm the group/workspace ID exists and the authenticated user has access.
    • Check network connectivity and Power BI service status.

Links and References

Discussion