Forum Discussion
OLE DB or ODBC error: [DataSource.Error] AnalysisServices : The XML for Analysis Request Timed out
I think even one hour is excessive. Keep in mind that while you are using the renderer no other user in your capacity can use that renderer. You will want to complete your query in the least amount of time possible so that the renderer can be released and reassigned.
HI krish11,
This error message means your requests have exceeded the timeout limits and the remote database breaks the connections.
As lbendlin said, you can configure the timeout property on data connection but the database configurations should have higher priority.
You can use them to set a small number to ignore the large-time operations but they weren't able to increase the database connection timeout.BTW, you can take a look at the below link which mentions the optimization guide of power bi.
Optimization guide for Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
lbendlin Thank you for the reply.
As per your perspective, I don't need to add that Commandtimeout right?
I will do that. Thank you for the direction.
I think even one hour is excessive. Keep in mind that while you are using the renderer no other user in your capacity can use that renderer. You will want to complete your query in the least amount of time possible so that the renderer can be released and reassigned.