Power BI

Work with the Power BI API

Actions32

Admin Actions
- Get Workspace Information
- Get Scan Result
Dashboard Actions
Dataflow Actions
Dataset Actions
Gateway Actions
Group Actions
Report Actions

Overview

This node integrates with the Power BI API to perform various operations on Power BI resources. Specifically, for the Group resource with the Get operation, it retrieves information about a Power BI group (also known as a workspace). This is useful when you want to fetch details about a specific workspace in your Power BI environment, such as its metadata or configuration.

Common scenarios include:

Automating reports or dashboards by first retrieving workspace details.
Managing multiple workspaces programmatically.
Integrating workspace data into other workflows or systems.

For example, you might use this node to get the ID and name of a workspace before creating or updating reports within that workspace.

Properties

Name	Meaning
Authentication	Method used to authenticate with Power BI API. Options: OAuth2, Bearer Token.
Group Name or ID	The identifier of the Power BI group (workspace) to retrieve. You can select from a list or specify an ID using an expression.

Output

The node outputs JSON data representing the details of the requested Power BI group/workspace. The structure typically includes metadata such as the group's ID, name, description, and other relevant properties provided by the Power BI API.

If the node supports binary data output (not indicated here), it would represent files or media related to the group, but for the "Get" operation on groups, the output is purely JSON.

Dependencies

Requires access to the Power BI API.
Needs authentication credentials configured in n8n, either via OAuth2 or a Bearer Token.
Uses internal helper methods to load available groups dynamically for selection.

Troubleshooting

Common issues:
- Invalid or expired authentication tokens will cause authorization errors.
- Specifying a non-existent group ID will result in an error indicating the group was not found.
- Network connectivity problems may prevent API calls from succeeding.
Error messages:
- "The resource "group" is not supported!" — indicates an unsupported resource or misconfiguration.
- API errors returned from Power BI will be passed through; check the message for details like permission issues or invalid IDs.
Resolutions:
- Ensure valid and current authentication credentials are set up.
- Verify the group ID exists and is accessible with the provided credentials.
- Check network connectivity and API endpoint availability.