Forum Discussion

Eugene_Ov's avatar
Eugene_Ov
Helper I
5 years ago

XMLA dataset refresh timeout

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.   I'm on A1 tier, w...
Need Help
GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi Eugene_Ov 

 

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)

 

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?

 

Here are more details on how to complete the incremental refreshing: Incremental refresh in Power BI - Power BI | Microsoft Docs

Eugene_Ov's avatar
Eugene_Ov
Helper I
5 years ago

Hi GilbertQ 

No, that's not the case. I receive this error only after 15 or 20 minutes of processing.

Eugene