Forum Discussion
Check all planned refreshes
Hi community!
Is there any way - using Power BI / Power Automate - to check if all planned refreshes are succesully done for today?
I know there is the feature to get an email if a refresh has crashed.
But I would like to create a governance dashboard for all dataflow and dataset refresh to get an overview if everything runs well.
Do we have the chance to get the information to power bi if there is a refresh planned for a dataflow and dataset?
And if this refresh was done?
Hi joshua1990 ,
You can start with this one: Admin - Get Refreshables - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Then, take that information and separate it out as needed!
3 Replies
HI joshua1990 ,
I have already created something like this in the past - the way I did it was to use the API to get a list of all the Start Times and End Times of each Refresh for each Dataflow and Dataset and if it does not have an End Time then it is still running. This also allows me to use averages for how long to expect a refresh to take for any given dataset.
collinq : Thanks a lot for your reply! What API is it exactly?
Hi joshua1990 ,
You can start with this one: Admin - Get Refreshables - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Then, take that information and separate it out as needed!
