Actions24
- Admin Actions
- Dashboard Actions
- Dataset Actions
- Group Actions
- Report Actions
- Token Actions
Overview
This node integrates with the Power BI API using header-based authentication to retrieve detailed administrative information about selected workspaces (also called groups). It is particularly useful for administrators or analysts who need to gather comprehensive metadata and insights about multiple Power BI workspaces in an automated workflow.
Typical use cases include:
- Auditing workspace configurations and contents.
- Extracting dataset schemas and DAX expressions for documentation or analysis.
- Obtaining lineage information to understand data flow and dependencies.
- Collecting datasource details for troubleshooting or migration planning.
For example, a user can select several workspaces and request detailed info including dataset schemas and lineage, enabling them to generate reports on workspace health or compliance.
Properties
| Name | Meaning |
|---|---|
| Authentication Token | Bearer token for authenticating API requests (without the "Bearer" prefix). |
| Workspaces | Select one or more workspaces (groups) to retrieve information from. |
| Dataset Schema | Include dataset schema details in the output (boolean). |
| Dataset Expressions | Include DAX expressions used in datasets (boolean). |
| Lineage | Include data lineage information (boolean). |
| Datasource Details | Include details about data sources connected to the datasets (boolean). |
Output
The node outputs JSON data containing detailed information about each selected workspace. The structure includes:
- Workspace metadata such as ID, name, and description.
- Optionally, dataset schemas describing tables and columns.
- Optionally, DAX expressions used within datasets.
- Optionally, lineage information showing relationships between datasets and reports.
- Optionally, datasource details providing connection info and credentials metadata.
Each item in the output array corresponds to one workspace's aggregated information based on the selected options.
No binary data output is produced by this operation.
Dependencies
- Requires a valid Power BI API bearer token for authentication.
- The token must have sufficient permissions to access the admin APIs for the selected workspaces.
- No additional external services are required beyond the Power BI REST API.
- The node uses internal helper functions to load workspace options dynamically.
Troubleshooting
- Missing or invalid token: If the authentication token is missing or invalid, the node will throw an error indicating that the token is required or failed to authenticate. Ensure the token is current and has the necessary scopes.
- Workspace selection errors: If no workspaces are selected or the token lacks access to them, the node may return empty results or errors. Verify workspace IDs and token permissions.
- API rate limits or throttling: Large numbers of workspaces or detailed options may cause API throttling. Consider reducing the number of workspaces or disabling optional details.
- Network issues: Connectivity problems to the Power BI API endpoint will cause failures. Check network access and proxy settings if applicable.