Forum Discussion

krish11's avatar
krish11
Frequent Visitor
5 years ago
Solved

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

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....
  • lbendlin's avatar
    lbendlin
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    5 years ago

    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