Actions32
- Admin Actions
- Dashboard Actions
- Dataflow Actions
- Dataset Actions
- Gateway Actions
- Group Actions
- Report Actions
Overview
This node integrates with the Power BI API to retrieve detailed information about specified workspaces (referred to as "groups" in Power BI terminology). The "Get Workspace Information" operation under the "Admin" resource allows users to fetch comprehensive metadata and configuration details for one or more selected workspaces.
Typical use cases include:
- Auditing workspace configurations and contents.
- Extracting dataset schemas and expressions for analysis or migration.
- Gathering data lineage and datasource details to understand data flow and dependencies within Power BI environments.
For example, a user might select several workspaces to obtain their dataset schemas and expressions to document their reporting environment or to prepare for a migration to another platform.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating API requests. Options: OAuth2 or Bearer Token. |
| Workspace Names or IDs | Select one or multiple workspaces by name or ID to retrieve information from. |
| Dataset Schema | Whether to include the schema details of datasets within the selected workspaces (true/false). |
| Dataset Expressions | Whether to include dataset expressions (formulas, calculated columns/measures) in the output (true/false). |
| Lineage | Whether to include data lineage information showing data flow and dependencies (true/false). |
| Datasource Details | Whether to include detailed information about data sources connected to the datasets (true/false). |
Output
The node outputs an array of JSON objects, each representing detailed information about a selected workspace. The structure includes:
- Workspace metadata such as ID, name, and description.
- Dataset details including schema and expressions if requested.
- Data lineage information if enabled, illustrating how data flows between datasets and reports.
- Datasource details providing connection information to underlying data sources.
If multiple workspaces are selected, the output contains multiple such objects.
No binary data is produced by this operation.
Dependencies
- Requires access to the Power BI REST API.
- Requires authentication via either OAuth2 or a Bearer Token.
- The node depends on n8n credentials configured with appropriate permissions to query workspace information.
- The node uses internal helper methods to load available workspaces dynamically for selection.
Troubleshooting
Common Issues:
- Invalid or expired authentication tokens will cause authorization errors.
- Selecting workspace IDs that do not exist or to which the authenticated user lacks access will result in empty or error responses.
- Network connectivity issues can prevent API calls from succeeding.
Error Messages:
"The resource "admin" is not supported!"— This indicates an unsupported resource was selected; ensure "Admin" is chosen.- API errors related to permissions typically indicate insufficient rights; verify the API key or OAuth2 token scopes.
- If the node returns errors per item but continues execution, check the "Continue On Fail" setting to handle partial failures gracefully.