PowerBI Service Scheduled refresh failed

Hi Anonymous ,

It seems that gateway is working fine, the problem may come from your data source
1 When the data refresh fails more than 4 times, it will cause a failure.
2 A total refresh time of more than two hours will cause the data refresh to fail.

Please consider optimizing the model by removing unnecessary columns to reduce the size of the dataset or consider using advanced capacity to reduce the refresh time.

Optimization guide for Power BI - Power BI | Microsoft Docs

Troubleshooting refresh scenarios - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

UPDATE:

I opened a ticket with microsoft. After long investigation the issue was related to the internet bandwidth. the refresh was taking long time then failing. 

I couldn't change the bandwidth, I reduced the file size from 650 mb to 570 mb. now the refresh is working fine. But i am still thinking how would i manage this when file size grows again to reach the 650+ mb. everyday i have a growth of about 800 kb. simple math says : i have about 3 months remaining. 😨