Power BI icon

Power BI

Work with the Power BI API

Overview

This node integrates with the Power BI API to retrieve information about Power BI reports. Specifically, the Report - Get operation fetches details of a single report within a specified Power BI workspace (group). This is useful when you want to programmatically access metadata or properties of a specific report in your Power BI environment.

Common scenarios include:

  • Automating report management workflows by retrieving report details.
  • Integrating report metadata into other systems or dashboards.
  • Validating report existence or properties before performing further actions.

For example, you might use this node to get the ID, name, web URL, or dataset associated with a particular report in a given workspace.

Properties

Name Meaning
Authentication Method used to authenticate with Power BI API. Options: OAuth2 or Bearer Token.
Group (Workspace) Name or ID The Power BI workspace (group) where the report resides. Leave blank to use "My Workspace". You can select from a list or specify an ID via expression.
Report Name or ID The identifier of the report to retrieve. Required field. Choose from a list filtered by the selected workspace or specify an ID via expression.

Output

The node outputs JSON data representing the detailed information of the requested Power BI report. Typical fields in the output JSON may include:

  • Report ID
  • Report Name
  • Web URL to access the report
  • Dataset ID linked to the report
  • Other metadata related to the report's configuration and status

The output does not include binary data; it is purely JSON metadata describing the report.

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 to fetch groups (workspaces) and reports dynamically for selection lists.
  • No additional external dependencies beyond standard n8n credential setup and network access to Power BI services.

Troubleshooting

  • Invalid or missing authentication: Ensure that the OAuth2 or Bearer token credentials are correctly configured and have sufficient permissions to access the Power BI API.
  • Report not found: Verify that the provided report ID or name exists in the specified workspace. If using expressions, confirm they resolve correctly.
  • Workspace (Group) issues: If leaving the workspace blank to use "My Workspace," ensure the authenticated user has access to that workspace. Otherwise, select or specify a valid workspace ID.
  • API rate limits or connectivity errors: Check network connectivity and Power BI service status. Retry after some time if rate limits are hit.
  • Error messages: The node will throw errors if the resource or operation is unsupported or if required parameters are missing. Review error messages carefully and adjust input parameters accordingly.

Links and References

Discussion