Log run status in SQL table

[KBUIUS]

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 fine.  So we want to keep track of the running status, such as xxx time, was the run a fail/success and the error message by writing them into a SQL server table. Is this possible to have a centralized place to keep track of all dashboard status? 

I know in powerquery we might write data back into SQL, but it can't tell if the run was a success/failure. 

[Royel]

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