Notification if report not being refreshed (error with data)

[Anonymous]

I plan to create some tool that will send me a notification if data collection to SQL database and(or) from database to report failed.

Is it possible to somehow reach service (API) and get last refreshed time-date of every report?

[rainer1 · Accepted solution]

Hi @Anonymous ,

the Power BI Service have a api. You can call the refresh history or the failed refreshes.

See here: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory

By the way you can also activate the notification by email if a dataset refresh failed.

-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!