Forum Discussion

Dan_Sprague's avatar
Dan_Sprague
Advocate I
6 years ago

Getting Refresh Status for ALL Datasets

Hi All,    I know there's a lot of posts, blogs and articles out there about obtaining the last refresh date and status of datasets.  From what I've found, these solutions are either way too involv...
Need Help
Dan_Sprague's avatar
Dan_Sprague
Advocate I
6 years ago

Thanks for the reply Kelly.  Yes, refresh history can be viewed in the service.  The problem is that the history can only be viewed for a single dataset at a time.  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.  Not at all efficient.  

 

As stated in my original post, 

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.

 

  • gamos's avatar
    gamos
    Frequent Visitor
    3 years ago

    This is a reasonable reponse, but I think it's beyond the scope of what OP is asking for. 

    This solution you've linked assumes the following:
    - that the user has datasets in the Power BI service rather than in a .pbxi file
    - that the user is converstand in using Python + the requests module (or another programming language and its requests package)

    Is there not a  way one can glean all this information in a regular desktop Power BI report?