Power BI

Overview

This node integrates with the Power BI API, enabling users to interact programmatically with various Power BI resources such as dashboards, datasets, reports, gateways, groups, dataflows, and administrative workspace information. It is useful for automating tasks like retrieving workspace details, managing reports, or accessing dataset schemas within Power BI environments.

Practical examples include:

• Fetching detailed information about Power BI workspaces for auditing or reporting.
• Retrieving dashboard or report metadata to integrate with other business intelligence tools.
• Accessing dataset schemas to automate data lineage or impact analysis workflows.

Properties

Output

The node outputs JSON data representing the results of the selected operation on the chosen Power BI resource. The structure varies depending on the resource and operation but generally includes detailed metadata or data retrieved from Power BI (e.g., workspace info, dashboard details, dataset schemas).

If an error occurs during execution for any item, the output will contain an error message in JSON format for that item if "Continue On Fail" is enabled.

No binary data output is indicated by the source code.

Dependencies

• Requires valid authentication credentials for Power BI API access, either via OAuth2 or a bearer token.
• Uses internal helper methods to load options dynamically (e.g., available groups, dashboards).
• Relies on external modules providing resource-specific implementations for each operation.
• No explicit environment variables are mentioned, but proper credential setup in n8n is necessary.

Troubleshooting

• Common issues:

  • Incorrect or missing authentication credentials will cause API calls to fail.
  • Selecting unsupported resource-operation combinations will throw errors.
  • Network or API rate limiting issues may interrupt data retrieval.

• Error messages:

  • "The resource \"<resource>\" is not supported!" indicates an invalid resource selection.
  • Errors returned from the Power BI API will be surfaced in the output if "Continue On Fail" is enabled.

• Resolutions:

  • Verify authentication credentials and permissions.
  • Ensure the resource and operation selections are valid and supported.
  • Check network connectivity and API usage limits.

Links and References

• Power BI REST API Documentation
• n8n Documentation on Expressions
• OAuth2 Authentication Guide