PowerBI scheduled refresh fails. But still succeeds.

[tnewnham]

 Hi, running into a weird issue with my nightly refreshes. They can fail. But the report still updated properly... I am using an enterprise gateway that is up to date. I can refresh the report manually and it always succeeds. My IT team ensures that everything is set up properly.

Are there other logs that we can take a look at to diagnose this issue further?

Thank you

[v-jayw-msft]

Hi @tnewnham ,

Please check the document about how to export gateway logs.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot#export-logs-for... 

https://review.docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot#troubleshoot... 

Best Regards,

Jay

[collinq]

Hi @tnewnham ,

When you look at the settings for the dataset and the refresh history is it refreshing more than once during the night and so one might be failing and another succeeding?  The problem with the "Something Went Wrong" message is that we never quite know what went wrong.  There are other logs that you can have IT/O365 Administrators review.  This article will help you in the right direction for that:

Introducing the Power BI Activity Log | Microsoft Power BI Blog | Microsoft Power BI