Actions20
- Dataset Actions
- Group Actions
- Report Actions
- Admin Actions
- Dashboard Actions
Overview
This node interacts with the Power BI API to retrieve detailed information about selected workspaces (referred to as "workspaces" or "groups" in Power BI). Specifically, the "Obter Informações de Workspaces" operation under the "Admin" resource fetches comprehensive metadata and configuration details for one or more specified workspaces.
Typical use cases include:
- Auditing workspace configurations and contents.
- Extracting dataset schemas and expressions for documentation or analysis.
- Gathering lineage and data source details to understand data flow and dependencies within Power BI environments.
- Automating reporting or monitoring tasks related to workspace management.
For example, a user might select several workspaces to obtain their dataset schemas and expressions to generate a consolidated report on data models used across an organization.
Properties
| Name | Meaning |
|---|---|
| Workspaces | Select one or multiple workspaces to retrieve information from. |
| Dataset Schema | Include the schema details of datasets within the selected workspaces (true/false). |
| Dataset Expressions | Include dataset expressions such as calculated columns or measures (true/false). |
| Lineage | Include data lineage information showing how data flows between datasets and reports (true/false). |
| Datasource Details | Include detailed information about the data sources connected to the datasets (true/false). |
Output
The output is a JSON array where each item corresponds to the detailed information retrieved for the selected workspaces. The structure includes:
- Workspace metadata (e.g., workspace ID, name).
- Dataset details including schema and expressions if requested.
- Data lineage information if enabled.
- Data source details if enabled.
The exact JSON structure depends on the options selected but generally provides a rich hierarchical representation of workspace contents and configurations.
No binary data output is produced by this operation.
Dependencies
- Requires a valid Power BI API authentication token configured in n8n credentials.
- Access to the Power BI REST API endpoint:
https://api.powerbi.com/v1.0/myorg. - The node relies on internal helper methods to load available workspaces dynamically for selection.
Troubleshooting
Common Issues:
- Insufficient permissions: The API token must have adequate rights to access workspace and dataset information.
- Empty workspace selection: Ensure at least one workspace is selected; otherwise, no data will be returned.
- Network or API errors: Check connectivity and Power BI service status.
Error Messages:
"O recurso "<resource>" não é suportado!"— This indicates an unsupported resource was selected; verify that "admin" is chosen.- API errors returned from Power BI are surfaced as error messages in the output JSON when "Continue On Fail" is enabled.
Resolutions:
- Verify API credentials and permissions.
- Confirm workspace IDs are correct and accessible.
- Enable "Continue On Fail" to handle partial failures gracefully.