XMLA dataset refresh timeout

Question

Hi,I'm using XML/A endpoint and when trying to run Process Database, constantly get error 'The connection either timed out or was lost.' Database in this case doesn't process.&nbsp;I'm on A1 tier, when upgraded to A4, everything runs faster and timeout doesn't appear.&nbsp;Any info on timeout interval?&nbsp;Eugene

gilbertq · Answer

Hi&nbsp;Eugene_Ov&nbsp;
&nbsp;
The only other thing I can think of is that your model uses more memory than required on the A1 SKU, and that is why it works on an A4 SKU which has significantly more memory during the refresh.

gilbertq · Answer

Hi&nbsp;Eugene_Ov&nbsp;
&nbsp;
This would appear that on the lower SKU you do not have enough CPU's to process the data within the timeout (which defaults to 2 hours)
&nbsp;
I would suggest looking at incremental refreshing of your dataset which will only process the last N number of days instead of the entire dataset?
&nbsp;
Here are more details on how to complete the incremental refreshing:&nbsp;Incremental refresh in Power BI - Power BI | Microsoft Docs

eugene_ov · Answer

Hi&nbsp;GilbertQ&nbsp;No, that's not the case. I receive this error only after 15 or 20 minutes of processing.Eugene

v-kelly-msft · Answer

Hi&nbsp;Eugene_Ov&nbsp;,
&nbsp;
Check with your admin whether the setting of XLMA endpoint for A1 capacity has been set to 1?

&nbsp;
Below is the related reference:
https://radacad.com/what-is-the-xmla-endpoint-for-power-bi-and-why-should-i-care
&nbsp;
Best Regards,Kelly
Did I answer your question? Mark my post as a solution!

Forum Discussion

XMLA dataset refresh timeout

4 Replies

Related content

Dataset refresh error - timeout

Refresh dataset api

Incremental Refresh Timeout Issue with Large Dataset

Dataset Refresh Timeout Help!

dataset refresh