Showing results for 
Search instead for 
Did you mean: 

scheduled refresh fails and gives no error

I have at least 9 datasets connecting to the same same database.  All perform their scheduled refresh without incident, but 2 consistently fail.  They refresh for several hours before failing.  When I the warning icon, nothing happens.  When I click the "Last Refresh failed:" link, there is no refresh history.  In the Settings, Datasets, it says the "last refresh: undefined". 

Yes, i have reinstalled the latest Personal Gateway, as of 1/27.  Nothing is working.

Resident Rockstar
Resident Rockstar

This is the wrong forum for this question. It should go in the Service forum. Posting in the proper forum can help you to get better responses faster, and allows others with similar questions to more easily find your thread.


Can you tell us the size of the failing datasets? There is a 250MB limit for the data model in a hosted .pbix.

I have a similar issue.  Having just upgraded to the professional version, some datasets have updated without any issue.  However some have not.  The data source they use is an Azure database.   One example the details of the refresh is shown in the image.  Any ideas or suggestions are welcome 🙂

Refresh settings



Having same problem, update on this?

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps