Power BI icon

Power BI

Work with the Power BI API

Overview

This node interacts with the Power BI API to retrieve information about dashboards, specifically to get the tiles of a given dashboard within a workspace (group). It is useful for automating reporting workflows, monitoring dashboard contents, or integrating Power BI visuals into other systems.

For example, you can use this node to:

  • Extract all tiles from a specific Power BI dashboard to analyze or archive their configuration.
  • Automate the retrieval of dashboard components for embedding in custom portals.
  • Monitor changes in dashboard tiles as part of a data governance or auditing process.

Properties

Name Meaning
Authentication Method used to authenticate with Power BI API. Options: OAuth2, Bearer Token.
Group (Workspace) Name or ID The Power BI workspace (group) identifier. Leave blank to use "My Workspace". You can select from a list or specify an ID via expression.
Dashboard Name or ID The identifier of the dashboard to retrieve tiles from. Must be specified. Select from a list or provide an ID using an expression.

Output

The node outputs an array of JSON objects representing the tiles of the specified Power BI dashboard. Each item corresponds to a tile and contains its properties as returned by the Power BI API.

If the node supports binary data output (not explicitly shown here), it would typically represent images or visual content of tiles, but based on the code and context, the output is JSON only.

Dependencies

  • Requires access to the Power BI API.
  • Needs either OAuth2 authentication or a Bearer Token for API access.
  • The node depends on dynamic loading methods to fetch available groups (workspaces) and dashboards for user selection.
  • Proper permissions on the Power BI account to read dashboard and tile information are necessary.

Troubleshooting

  • Common issues:

    • Invalid or expired authentication tokens will cause API request failures.
    • Specifying a non-existent group or dashboard ID will result in errors.
    • Insufficient permissions on the Power BI workspace or dashboard may lead to authorization errors.
  • Error messages:

    • "The resource \"dashboard\" is not supported!" — This indicates an unsupported resource was selected; ensure "Dashboard" is chosen.
    • API errors related to authentication or authorization should be resolved by verifying credentials and permissions.
    • If the node fails on a particular item but "Continue On Fail" is enabled, error details will be included in the output for that item.

Links and References

Discussion