Power BI icon

Power BI

Work with the Power BI API

Actions32

Overview

This node interacts with the Power BI API to retrieve information about dashboards within a specified workspace (group). The "Get" operation under the "Dashboard" resource fetches details of a specific dashboard by its ID. This is useful for scenarios where you want to programmatically access dashboard metadata, such as its name, description, or other properties, to integrate with reporting workflows, automate monitoring, or synchronize dashboard data with other systems.

Practical examples:

  • Automatically retrieving dashboard details to display in a custom portal.
  • Using dashboard metadata to trigger alerts or updates in other applications.
  • Integrating Power BI dashboard info into automated reports or notifications.

Properties

Name Meaning
Authentication Method used to authenticate with Power BI API. Options:
- OAuth2
- Bearer Token
Group (Workspace) Name or ID Power BI group (workspace) identifier. Leave blank to use the default "My Workspace". You can select from a list or specify an ID via expression.
Dashboard Name or ID Identifier of the dashboard to retrieve. Required field. Select from a list filtered by the chosen group or specify an ID via expression.

Output

The node outputs an array of JSON objects representing the retrieved dashboard(s). Each object contains detailed metadata about a Power BI dashboard, such as its ID, name, and potentially other descriptive fields provided by the Power BI API.

If the node supports binary data output (not indicated explicitly here), it would typically represent exported dashboard content or related files; however, this node focuses on JSON metadata output only.

Dependencies

  • Requires valid authentication credentials for Power BI API access, either via OAuth2 or a bearer token.
  • The node depends on the Power BI API endpoints for groups (workspaces) and dashboards.
  • Proper configuration of authentication credentials in n8n is necessary.
  • The node uses internal helper methods to load available groups and dashboards dynamically for user selection.

Troubleshooting

  • Common issues:

    • Invalid or expired authentication tokens will cause authorization errors.
    • Specifying a non-existent group or dashboard ID will result in not found errors.
    • Network connectivity problems may cause request failures.

  • Error messages and resolutions:

    • "The resource \"dashboard\" is not supported!" — indicates an unsupported resource was selected; ensure "Dashboard" is chosen.
    • Authorization errors suggest checking and refreshing the API credentials.
    • If no dashboards appear in the dropdown, verify that the selected group has dashboards and that the API permissions allow listing them.

Links and References

Discussion