Power BI icon

Power BI

Work with the Power BI API

Actions20

Overview

This node interacts with the Power BI API to retrieve information about reports and their pages within a specified workspace (group). The "Get Pages" operation under the "Report" resource fetches all pages of a given report. This is useful when you want to programmatically access or analyze the structure of a Power BI report, for example, to list all report pages for documentation, auditing, or further automated processing.

Practical examples:

  • Automatically generating a list of all pages in a report to create a navigation menu.
  • Extracting page metadata for reporting or integration with other systems.
  • Validating report contents by checking the presence of expected pages.

Properties

Name Meaning
Group (Workspace) Power BI group (workspace) ID. Choose from available workspaces. Leave blank to use "My Workspace".
Report ID ID of the report to retrieve. Select from reports available in the chosen workspace.

Output

The output JSON contains an array of objects representing the pages of the specified report. Each object typically includes details such as page name, display name, and possibly other metadata related to each page in the report.

If the node supports binary data output (not indicated here), it would represent any associated binary content related to the report pages, but this operation primarily returns JSON metadata.

Dependencies

  • Requires a valid Power BI API authentication token configured in the node credentials.
  • The node depends on the Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg.
  • The user must have appropriate permissions to access the specified workspace and report.

Troubleshooting

  • Common issues:

    • Invalid or missing workspace (group) ID can cause errors or empty results.
    • Incorrect report ID or lack of access rights to the report will result in failure to retrieve pages.
    • Network or authentication failures may prevent API calls.

  • Error messages:

    • "The resource \"report\" is not supported!" — indicates an unsupported resource was selected; ensure "Report" is chosen.
    • API errors returned from Power BI (e.g., 401 Unauthorized, 404 Not Found) usually mean invalid credentials or incorrect IDs.

  • Resolutions:

    • Verify that the API key or authentication token is correctly set up and has sufficient permissions.
    • Double-check the workspace and report IDs are correct and accessible.
    • Use the "Group (Workspace)" property to select the correct workspace context.

Links and References

Discussion