PowerBI Refresh Fail Emails

[Anonymous]

We are consistently receiving the PowerBI Refresh Fail Email notifications for our 6am refreshes. When we look at our reporting dashboard however, it sometimes notes that it was last refreshed at around 6am even though we received the failure email. Due to this, we are never sure if the refresh actually went through or not. Also, one of my team member and I are constantly seeing differences on each of our applications at the same time. He will see a more updated refresh than I will even though I refreshed my browser and cleared the cache on my computer. We will need someone to look into this so we can put processes in place to properly manage our production data generated by these reports. 

[GilbertQ]

Hi @Anonymous 

What I have done is to create a way to download the Power BI Refresh history using the APIs which I then use to create a report which everyone can then use.

Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn