Actions24
- Admin Actions
- Dashboard Actions
- Dataset Actions
- Group Actions
- Report Actions
- Token Actions
Overview
This node enables interaction with the Power BI API using header-based authentication via a bearer token. Specifically, the Dataset - Refresh operation triggers a refresh of a specified dataset within a Power BI workspace (group). This is useful when you want to programmatically update your Power BI datasets to reflect the latest data without manual intervention.
Common scenarios include:
- Automating dataset refreshes after data ingestion pipelines complete.
- Scheduling dataset updates as part of broader reporting workflows.
- Triggering refreshes on-demand from other systems or user actions.
Example: After loading new sales data into a database, use this node to refresh the corresponding Power BI dataset so reports and dashboards show updated figures.
Properties
| Name | Meaning |
|---|---|
| Authentication Token | Bearer token for authenticating API requests (without the "Bearer" prefix). Required. |
| Group (Workspace) | Power BI group (workspace) ID where the dataset resides. Leave blank to use "My Workspace". |
| Dataset | The ID of the dataset to refresh. Required. |
Output
The node outputs JSON data representing the response from the Power BI API after attempting to refresh the dataset. Typically, this includes status information about the refresh request.
The output json field structure depends on the API response but generally contains fields such as:
- Refresh status
- Request ID or correlation ID
- Timestamps or metadata related to the refresh operation
No binary data is produced by this operation.
Dependencies
- Requires a valid Bearer authentication token for the Power BI API with permissions to refresh datasets.
- The token can be provided either as an input to the node or set in the node parameter.
- No additional external dependencies beyond access to the Power BI REST API endpoint (
https://api.powerbi.com/v1.0/myorg).
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 unauthorized. Ensure the token is current and has the necessary scopes.
- Invalid group or dataset ID: Providing incorrect workspace (group) or dataset IDs will cause API errors. Verify these IDs are correct and accessible by the authenticated user.
- API rate limits or service issues: Power BI API may throttle requests or experience downtime. Retry logic or error handling should be implemented in workflows.
- Error messages typically include HTTP status codes and messages from the Power BI API. Review these messages to diagnose permission issues or resource not found errors.