Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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

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.

1 REPLY 1
Anonymous
Not applicable

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)?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.