cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shankarshiva70
Helper III
Helper III

The XML for Analysis request timed out before it was completed. Timeout value: 18000 sec

Hi,

 

I am getting error while refreshing the dashboard on power bi service.

Data source is SQL and it is around 1.2 GB. 

How can I resolve this issue. Please help

shankarshiva70_0-1626329292428.png

 

Thanks.

1 ACCEPTED SOLUTION
Eyelyn9
Community Support
Community Support

Hi @shankarshiva70 ,

 

As stated in this blog, refreshing the dataset will give an error message indicating you that your dataset is too large when data model size grows beyond 1 GB.(yours is around 1.2GB)

 

I would recommend you

1. Make sure your on-premise gateway is the lateset version.

2.Use Power BI Desktop to check the refresh duration.If it takes more than 2 hours, consider moving your dataset to Power BI Premium. Your dataset might not be refreshable on shared capacity. Also consider using Incremental refresh for datasets that are larger than 1GB or take several hours to refresh.

3. Set the Time out parameter on the connection. Try setting this to something larger than 3600, like 7200 for 2 hours or even 36000 for 10 hours. Default number if you put nothing = 10min

4. Break up your dataset into smaller datasets and refresh them in Power BI Service .

 

Refer to:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#best-practices

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

https://community.powerbi.com/t5/Service/Timeout-value-in-powerbi-service/m-p/1570341

https://community.powerbi.com/t5/Service/data-refresh-timeout-works-sometimes-fails-others/m-p/10207...

 

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

View solution in original post

2 REPLIES 2
OlapOffice
Helper II
Helper II

The Premium limit I believe is 5 hours only. https://blog.crossjoin.co.uk/category/premium/

 

Eyelyn9
Community Support
Community Support

Hi @shankarshiva70 ,

 

As stated in this blog, refreshing the dataset will give an error message indicating you that your dataset is too large when data model size grows beyond 1 GB.(yours is around 1.2GB)

 

I would recommend you

1. Make sure your on-premise gateway is the lateset version.

2.Use Power BI Desktop to check the refresh duration.If it takes more than 2 hours, consider moving your dataset to Power BI Premium. Your dataset might not be refreshable on shared capacity. Also consider using Incremental refresh for datasets that are larger than 1GB or take several hours to refresh.

3. Set the Time out parameter on the connection. Try setting this to something larger than 3600, like 7200 for 2 hours or even 36000 for 10 hours. Default number if you put nothing = 10min

4. Break up your dataset into smaller datasets and refresh them in Power BI Service .

 

Refer to:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#best-practices

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

https://community.powerbi.com/t5/Service/Timeout-value-in-powerbi-service/m-p/1570341

https://community.powerbi.com/t5/Service/data-refresh-timeout-works-sometimes-fails-others/m-p/10207...

 

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

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors