Actions24
- Admin Actions
- Dashboard Actions
- Dataset Actions
- Group Actions
- Report Actions
- Token Actions
Overview
This node interacts with the Power BI API using header-based authentication. Specifically, for the Dataset - Get operation, it retrieves detailed information about a specified dataset within a Power BI workspace (group). This is useful when you want to programmatically access metadata or properties of datasets in your Power BI environment.
Common scenarios include:
- Automating reporting workflows by fetching dataset details.
- Integrating dataset metadata into other systems or dashboards.
- Validating dataset existence and properties before performing further operations like refresh or querying.
Example: You have multiple datasets in different workspaces and want to retrieve their schema or metadata automatically as part of a data pipeline.
Properties
| Name | Meaning |
|---|---|
| Authentication Token | Bearer token for authenticating API requests (without the "Bearer" prefix). |
| Group (Workspace) | Power BI workspace ID where the dataset resides. Leave blank to use the default "My Workspace". |
| Dataset | The ID of the dataset to retrieve information about. |
Output
The node outputs JSON data representing the dataset's details as returned by the Power BI API. This typically includes dataset metadata such as its name, ID, tables, relationships, and other configuration details.
If multiple input items are processed, the output will be an array of such dataset objects corresponding to each input.
The node does not output binary data.
Dependencies
- Requires a valid Bearer authentication token for the Power BI API.
- The token must have sufficient permissions to access the specified workspace and dataset.
- No additional external dependencies beyond the Power BI REST API.
- No internal credential names are exposed; users must provide the token manually or via upstream nodes.
Troubleshooting
- Missing or invalid token: If the authentication token is missing or incorrect, the node will throw an error indicating that the token is required or invalid. Ensure the token is current and has the necessary scopes.
- Invalid group or dataset ID: Providing an incorrect workspace or dataset ID will result in API errors. Verify IDs are correct and accessible with the provided token.
- API rate limits or connectivity issues: Network problems or hitting Power BI API limits may cause failures. Retry after some time or check network connectivity.
- Error parsing response: Unexpected API responses might cause processing errors. Check if the Power BI service is operational and the API version is supported.