Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-eqin-msft
Community Support
Community Support

Hi @Anonymous ,

 

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/1020774

 

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

3 REPLIES 3
OlapOffice
Helper II
Helper II

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

 

v-eqin-msft
Community Support
Community Support

Hi @Anonymous ,

 

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/1020774

 

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.

Ciao, il mio data set non si aggiorna, come devo fare per seguire questo suggerimento: 

 3. Impostare  il parametro Timeout sulla connessione. Prova a impostarlo su qualcosa di più grande di 3600, come 7200 per 2 ore o anche 36000 per 10 ore. 

Grazie in anticipo a chi mi può aiutare 

Denis

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors