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 

AdmVarr's avatar
AdmVarr
Frequent Visitor
1 year ago

Hi lbendlin .
Thank you for the reply. I have just done this and run the query through SSMS and it run in less than 1 second (returned 00:00:00) to retrieve the data. 

Simarly, have run the DAX through DAX Studio and the Server timings are 67ms on the storage engine and 150ms on the formula engine.

 

I'm confused by the way it works in Power BI desktop and not on service, and even more so that it works on 2 out of our 3 production servers on service without an issue. I have asked my IT team to run some diagnostics on the server to elimate anything on that end but feel i'd have the same issue in desktop if that was the case?

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Testing this on the desktop has indeed limited value.

     

    Can you reliably reproduce it on the service or is it a "transient"  issue? Is a gateway involved?

    • AdmVarr's avatar
      AdmVarr
      Frequent Visitor
      1 year ago

      Thanks again for you time lbendlin 

      I have tried publishing to a few different premium workspaces and get the same issue but guess it could be transient, unsure how else to test this. Unfortuantely high priority as is displayed in our contact centre wallboard showing Overdue activities. There is indeed a gateway involved, but the same gateway being used for all other reporting (including the other 2 working versions of the report). We did upgrade to the latest gateway version ~1 week ago but was working all of last week, only went down today so would be surpised if it was this. I guess we could roll back to test this but feels like this should be a last resort?