Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Query update performance

The query update process since the February update of yesterday is much, much slower, by a factor of many times. It appears in the interest of making PBIX saves faster, this is now much slower. I am waiting for about 945MB update to finish for 30 minutes now after I sorted the table in . I have never had an issue like this before and have plenty of RAM and CPU.  It is pegging both pretty hard but seems to be caught in a loop.  Other queries finish but still much slower than before. 

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @DQuigg,

 

Please follow this article to find which query causes the issue: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance#deep-dive-into-query-performa...

 

As there is a known issue which table sort by column reset after refresh, there will be a new desktop version as mentioned by AlexGorev. Please test again when the next version is released. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info