Forum Discussion
Log run status in SQL table
Hi, We have a lot of Powerbi dashboards on RS at my workplace. The problem is some of them might fail and we can't go through every single one of them everyday to check if the refresh was running f...
Hi KBUIUS, with having lots of dataset for your reports and dashboards you are getting defficulties to check dataset refreshes perform successfully or failed.
To overcome this issue, we have an excillent alternet solutions. Just create a install cloud flow (power automate) to refresh your all dataset. In a single flow, you can add 150 dataset.
Once, dataset added then add a condition when your dataset refresh gets failed, get a email notification.
To do that, follow @Wicak response, so that you will only get mail, if certain dataset refresh get fail.
Let me know, if you face any issues.
If I have answered your question or solved your problem, please mark this post as solved.
If you liked my response, please give Kudos
Thanks,
Royel