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 Report resource with the List operation, it retrieves a list of reports available in a specified Power BI workspace (group). This is useful when you want to automate workflows that involve fetching report metadata or enumerating reports for further processing.

Common scenarios:

  • Automatically listing all reports in a workspace to generate summaries or dashboards.
  • Fetching report IDs and names to use as inputs for other Power BI operations like exporting or embedding reports.
  • Integrating Power BI report data into other systems by first retrieving the list of available reports.

Example:
You want to get all reports from your "Sales" workspace to send an email summary or trigger downstream analytics workflows based on those reports.

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 Power BI report retrieved from the specified workspace. Each report object typically contains metadata such as report ID, name, web URL, and possibly other details depending on the API response.

If the node supports binary data output (not explicitly shown here), it would represent report content or exported files, but for the List operation, the output is purely JSON metadata about reports.

Dependencies

  • Requires access to the Power BI REST API.
  • Needs either OAuth2 credentials or a Bearer Token configured in n8n for authentication.
  • Uses internal helper methods to load groups (workspaces) dynamically for selection.
  • No additional external dependencies beyond standard HTTP requests to Power BI API.

Troubleshooting

  • Authentication errors: Ensure that the OAuth2 token or Bearer Token is valid and has sufficient permissions to access the Power BI workspace.
  • Empty results: Verify that the specified group/workspace ID is correct and that there are reports available in that workspace.
  • API rate limits: Power BI API may throttle requests; if you encounter rate limit errors, consider adding delays or retries.
  • Invalid group ID: If the group ID does not exist or the user lacks access, the node will throw an error. Double-check the workspace ID or leave blank to use "My Workspace".
  • Continue on Fail: If enabled, the node will continue processing other items even if one fails, returning error details in the output.

Links and References

Discussion