Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Schedule refresh is failing evertime

The scheduled refresh is failing almost everytime  in power bi service. My datasource is Microsoft Dynamics 365. Please find below screenshot of the error.



power bi.JPG


The dataset size is 254 MB. I don't think size is the issue here because I have another dataset whose size is 280 MB and refresh is completed successfully for that dataset.This is really frustating.


Kindly please help me on this. 


Kind Regards

Amit Kumar

Not applicable

Go to the General tab of the Settings page for the site you want to configure for subscriptions:

If you have a single site, at the top the browser window, click Settings and General.
If you have multiple sites, select the site you want to configure and click Settings and General.
On the General page, do the following:

Under Refresh Failure Notifications, select Send email to data source and workbook owners when scheduled refreshes fail.

To clarify, if a scheduled refresh for a particular data source fails, the email goes only to the owner of that data source, not to owners of workbooks that connect to that data source.

Super User
Super User

Well, it could be the size coupled with the operations being performed by the query as well as perhaps this source system is slower than the other. You could check the Issues forum here:

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to Scroll down and click "CREATE SUPPORT TICKET".

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

Helpful resources

September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors