Power BI icon

Power BI

Work with the Power BI API

Actions32

Overview

This node interacts with the Power BI API to retrieve information about dataflows within a specified workspace. Specifically, the "Get Dataflow" operation fetches the definition of a particular dataflow by its name or ID from a selected workspace.

Common scenarios where this node is beneficial include:

  • Automating the retrieval of dataflow metadata for auditing or documentation purposes.
  • Integrating Power BI dataflows into broader ETL or data orchestration workflows.
  • Monitoring or managing dataflows programmatically without manual intervention in the Power BI portal.

For example, a user might use this node to automatically fetch and log the configuration details of a dataflow whenever it is updated, enabling version control or change tracking.

Properties

Name Meaning
Authentication Method used to authenticate with Power BI API. Options: OAuth2, Bearer Token.
Workspace Name or ID The workspace (group) that contains the target dataflow. Can be selected from a list or specified by ID.
Dataflow Name or ID The specific dataflow to retrieve. Can be selected from a list filtered by the chosen workspace or specified by ID.

Output

The node outputs JSON data representing the detailed definition of the requested dataflow. This typically includes metadata such as the dataflow's structure, entities, transformations, and other configuration details as provided by the Power BI API.

No binary data output is indicated for this operation.

Dependencies

  • Requires access to the Power BI API.
  • Needs appropriate authentication credentials configured in n8n, either via OAuth2 or a bearer token.
  • The node depends on dynamic loading of available workspaces and dataflows through helper methods to populate selection options.

Troubleshooting

  • Common Issues:

    • Invalid or expired authentication tokens can cause authorization failures.
    • Specifying a workspace or dataflow ID that does not exist or to which the user lacks access will result in errors.
    • Network connectivity issues may prevent successful API calls.

  • Error Messages:

    • "The resource "dataflow" is not supported!" — indicates an unsupported resource was selected; ensure "Dataflow" is chosen.
    • API error messages related to authentication or permissions should be resolved by verifying credentials and user access rights.
    • If the node returns an error about missing parameters, confirm that both workspace and dataflow fields are correctly set.

Links and References

Discussion