Forum Discussion

AdmVarr's avatar
AdmVarr
Frequent Visitor
1 year ago
Solved

XML for Analysis Timeout

Apologies if this is covered elsewhere however I can't find any resources with the same issues I am facing. I am getting the error: The XML for Analysis request timed out before it was completed. ...
Need Help
  • AdmVarr's avatar
    AdmVarr
    1 year ago

    I completely rebuilt the report from scratch and it now works fine. It's identical in every way so although I haven't got to the bottom of the issue, I will mark this as solved.

    Really do appreciate the time you spent lbendlin 

lbendlin's avatar
lbendlin
Super User
1 year ago

Use Performance analyzer to capture the query (the Direct Query version) and then run that query through SSMS and evaluate the Actual Execution Plan.  Modify or add indexes accordingly. Make sure to update statistics too.