Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to create a Power BI report that monitors all of your dataflows / datasets / reports so you can open up 1 report and see what has failed to refresh? I know where to see it in the service but it would be nice to have a report to monitor everything. Thanks.
-Scott
Hi TB12,
There is an idea posted on the same, you might like to upvote it
View of all Datasets and Refresh Status - Microsoft Power BI Community
There's a module called MicrosoftPowerBIMgmt that helps with logging in and some API calls.
MicrosoftPowerBIMgmt.Profile Module | Microsoft Docs
Regards,
Ritesh
Yes it is possible. But its alot of work too.
You can leverage the Power BI Rest API, to pull all the datasets ID. Then using the dataset ID, pull the dataset refresh status using another API. And automate all this using you choice of tools and store in a list eg sharepoint. Then report this in Power BI Desktop.
Thanks for your reply. Do you have any links or helpful documentation I could read to try to do this? Thanks.
I havent seen any documentation that will walk you through the end-to-end solution.
But this is the API do you will need.
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history
The next thing is to automate it using power automate ( there are many options for automation):
https://www.youtube.com/watch?v=kgTHMDuvHY8
Thanks for the links, I'll take a look at them.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.