Forum Discussion
Refresh all Datasets in Workspace via restAPI
How do you refresh all datasets in a particular workspace?
I am currently using a LogicApp script to periodically refresh a particular dataset in a workspace hosted in our Premium Capacity.
Now I thought I remembered there was a Power BI restAPI that would let you refresh ALL datasets in a given workspace with one call.
However, I can't seem to find this API in the documentation anymore.
Does anyone know the name of the API to use?
Or am I mistaken and there is/was no such API.
Many thanks!
Jan
2 Replies
Hi JSiebrecht ,
The Power BI Refresh Dataset REST API enables dataset-refresh operations to be carried out asynchronously. Long-running HTTP connections from client applications aren't necessary. Compared to standard refresh operations, Enhanced refresh with the Refresh Dataset REST API provides more customization options and features beneficial for large models:
- Batched commits
- Table and partition-level refresh
- Apply incremental refresh policies
- Get refresh operation details
- Cancel refresh operations
Here are some documents, please check if theses could helps you a little:
Enhanced refresh with Power BI REST API - Power BI | Microsoft Docs
Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I guess I was just mistaken.
Maybe there never was one API that refreshed all datasets in a given workspace at once.
One would need to determine the list of datasets in the workspace with "Datasets - Get Datasets In Group" API, then loop over the list and trigger a refresh one by one.
PowerShell example may be found here:
https://technovert.com/blog/refreshing-all-datasets-in-power-bi-using-rest-api/
