Create a report to monitor all Power BI datasets and dataflows

[Anonymous]

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

[ribisht17]

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

[Tutu_in_YYC]

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.

[Anonymous]

Thanks for your reply.  Do you have any links or helpful documentation I could read to try to do this?  Thanks.

[Tutu_in_YYC]

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

[Anonymous]

Thanks for the links, I'll take a look at them.