why is my refresh failing? and sometimes disabling the refresh schedule?

[Anonymous]

I have a report that is published online for multple users to see.  It is connected to some SQL tables and some CSVs.

Its setup using a gateway for the sql tables, and service account credentials for the csvs storing in sharepoint.

The refresh fails ALL the time.  The error just says "The last refresh attempt failed because of an internal service error."

That obviously leads me to believe it is a problem on PowerBI's side.  It works fine most of the time, but it seems at least once a day it stops updating.

Sometimes it just turns off the schedule refresh.

[Anonymous]

I wouldn't just assume its a PowerBI fault for the refresh failure.  You will want to consider all of the variables that go into making a refresh happen.

For example, you might have a dataset in Power BI that connects via a Gateway to a Database Warehouse.  If your refresh is occuring at peak periods, your database might not be responding appropriately.  The gateway might be overloaded.  The data warehouse could be in the middle of an update process.  What version of the on-premise gateway is in use, is it up to date?

How long does a usual refresh take? Is it quick (2 minutes or less)? Is it slow (10 minutes plus)?