PowerBI Service Scheduled refresh failed

[MajeedKhan]

Hi all, 

PowerBI Scheduled refresh fails with following message.

Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 8b4daa7e-f3e7-4ce3-b365-4b205ce1450e
Request ID: 8564f1f0-6ad6-4f0a-a9ed-ad4278681ec5
Time: 2022-06-15 05:39:54Z

the Gateway connection seems fine

I appreciate your support

[v-chenwuz-msft · Accepted solution]

Hi @MajeedKhan ,

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.

[MajeedKhan · Accepted solution]

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. 😨 

[MajeedKhan]

Hi @v-chenwuz-msft 

I appreciate your support and time. My file size is about 600 mb. I think its not that big. 

i optimized it but still have the same problem. maybe the issue is the internet connction. i will check with our admin and write you back. i also reviewed the Troubleshooting refresh scenarios - Power BI | Microsoft Docs . Nothing worked. 

I will try to work on the upload speed for my internet with the admin and get back to you. 

[v-chenwuz-msft]

Hi @MajeedKhan ,

Whether the refresh is successful in power bi desktop?

Best Regards

Community Support Team _ chenwu zhu

[MajeedKhan]

If I click the refresh button on the home tab, the refresh is successul.

so for your quesiton Whether the refresh is successful in power bi desktop? answer is Yes

[v-chenwuz-msft]

Hi @MajeedKhan ,

Ok, I can't reproduce your situation so recommend that you could create a support ticket.

Please refer to the gif how to create the support ticked.

Best Regards

Community Support Team _ chenwu zhu

[v-chenwuz-msft · Accepted solution]

Hi @MajeedKhan ,

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.