OLE DB or ODBC error: [DataSource.Error] AnalysisServices : The XML for Analysis Request Timed out

[krish11]

I have this error coming in Power BI desktop when am trying to refresh. In this report used Analysis services and excel sourecs.

I am new to this AAS model concept. I am getting this below error.

I tried below command in Power query editor's Advance editor:

CommandTimeout=#duration(0,24,0,0) 

But still getting same error. I am not sure what's the exact issue. Can I repair this from Desktop or I need to fix something on analysis service side?

I appriciate any help. Please help me.

@amitchandak  @parry2k @Fowmy @v-rzhou-msft @selimovd 

[lbendlin · Accepted solution]

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.

[v-shex-msft · Accepted solution]

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]

24 Hours? You are willing to wait 24 hours?  Thankfully the SSAS server did cut you off after an hour.  Their timeout always overrides your timeout.

Talk to the cube owner and ask them to help you with improving the query performance.

[krish11]

@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.

[lbendlin · Accepted solution]

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.