cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Performance problems - XML for Analysis request timed out

I have a matrix, let's call it Matrix-A, in my report showing a few, quite complex, measures per customer. It was never fast, but it worked.

 

I recently made som changes to the report, on other pages than the one described above, with august version of powerbi desktop. I did not change any of the measures referenced in Matrix-A.

 

Once published in a test workspace I noticed that Matrix-A started to timeout with the error "The XML for Analysis request timed out before it was completed". It couldn't render the matrix.

 

After that I tried a lot of things but couldn't get it working again without removing a few measures.

 

Today I downloaded the previous version of the report (which is still working in power bi service), saved it with september version of power bi desktop without changing anything. Published it again under a new name, and now that report also gets the timeout.

 

To verify I downloaded the previous version again under a new name. Opened it with september version of power bi desktop, changed nothing and published it without saving, and that one still works in power bi service.

 

That leads me to believe that something has changed with power bi desktop that affects how the reports perform in power bi service. Has anyone else experienced this?

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Performance problems - XML for Analysis request timed out

Hi @mifi,

You can take a look at the feature summary blog of power bi to confirm if they add new timeout properties of dax expression calculate.

Power BI September 2020 Feature Summary 

In addition, maybe you can try to optimization the DAX expressions and try again to confirm if this fixed the issues.

Optimization guide for Power BI 

DAX optimization examples 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Frequent Visitor

Re: Performance problems - XML for Analysis request timed out

Hi @v-shex-msft Thank you for the links.

 

I might be able to do some optimizations but what I find very strange here is that the reports works differently depending on what version of Power BI Desktop it was saved with.

 

* Saved and published with september version of Power BI Desktop without any actual changes made = doesn't work, timeout at about 2 minutes.

* Published through, but not saved with, september version = works, gives response within 20 seconds

Highlighted
Community Support
Community Support

Re: Performance problems - XML for Analysis request timed out

Hi @mifi,

It sounds interesting, perhaps you can try to contact to power bi team with your sample file to help them to confirm if any internal properties/options changes that cause the issue. (e.g. add some timeout check or maximum timeout on formula calculations)

submit a support ticketsubmit a support ticket

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!