Getting Refresh Status for ALL Datasets

Question

Hi All,&nbsp;&nbsp;I know there's a lot of posts, blogs and articles out there about obtaining the last refresh date and status of datasets.&nbsp; From what I've found, these solutions are either way too involved or don't provide enough results.&nbsp; They're either about showing the last refresh for a single dataset/report, or doing something crazy like accessing the REST API with python/powershell, or creating an Azure application or Flow solution... that just seems like overkill and a lot of unneccessary work for what I'm trying to accomplish.&nbsp;What I'd like to do is simply create a new Power BI report, get the last refresh date and status for every dataset in our organization, display that info in the report, and publish it, as a "Refresh Status Dashboard"... and without using external tools, just power bi and power query.&nbsp;Does anyone know if this is possible or have any advice.&nbsp;Thank you much!&nbsp;

rajathirathi · Answer

Hi&nbsp;Dan_Sprague,&nbsp;Could you please help if you have achieved this .I want to do the same need to create report that shows refresh status for all dataset&nbsp;Thanks in advance

v-kelly-msft · Answer

Hi&nbsp;Dan_Sprague ,&nbsp;Below are the steps about getting the refresh history of datasets:Select a workspace you need &gt;go to settings&gt;datasets:Here you will find the refresh history of all the datasets in the workspace,such as below:&nbsp;But it cant be published directly to a dashboard,it needs to be done manually,&nbsp;For the related reference,pls click here.&nbsp;Best Regards,Kelly&nbsp;

dan_sprague · Answer

Thanks for the reply Kelly.&nbsp; Yes, refresh history can be viewed in the service.&nbsp; The problem is that the history can only be viewed for a single dataset at a time.&nbsp; If you have to check the refresh history and status of 100 datasets, you'd have to go through the steps you laid out one hundred times.&nbsp; Not at all efficient.&nbsp;&nbsp;&nbsp;As stated in my original post,&nbsp;What I'd like to do is simply create a new Power BI report, get the last refresh date and status for&nbsp;every&nbsp;dataset in our organization, display that info in the report, and publish it, as a "Refresh Status Dashboard"... and without using external tools, just power bi and power query.&nbsp;

v-kelly-msft · Answer

Hi Dan_Sprague ，&nbsp;If so,it's best to use API,pls turn to the references below:&nbsp;https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistoryingroup#completed-refresh-examplehttps://community.powerbi.com/t5/Developer/How-to-get-refresh-history-of-dataset-using-powerbi-REST-API/td-p/455555&nbsp;Best Regards,Kelly&nbsp;Did I answer your question? Mark my post as a solution!

anonymous · Answer

Hi&nbsp;@Dan_Sprague&nbsp;Were you able to achieve this - "simply create a new Power BI report, get the last refresh date and status for&nbsp;every&nbsp;dataset in our organization, display that info in the report, and publish it, as a "Refresh Status Dashboard"... and without using external tools, just power bi and power query."&nbsp;If yes, then please let me know. I am also planning to implement this.&nbsp;Thanks!!

Forum Discussion

Getting Refresh Status for ALL Datasets

8 Replies

Related content

Refresh dataset api

Getting “DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError” During Dataset Refresh

dataset refresh

Refreshing dataset

Getting error while refreshing Power BI dataset