https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SLOW-Excel-after-changing-filters/m-p/2527419#M70732 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="343197" data-lia-user-login="Momie2005" class="lia-mention lia-mention-user">Momie2005</a>&nbsp;</P><P>This is why I dumped excel. The DAX engine is different in excel than power bi. I don't know the details. However, excel is much more faster in one case, which is when you have a large number of queries. Excal can handle tens of queries while power bi crashes &nbsp;</P> Thu, 19 May 2022 18:54:48 GMT tamerj1 2022-05-19T18:54:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SLOW-Excel-after-changing-filters/m-p/2527323#M70716 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I'm working with a financial team (they love EXCEL<span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span>), and we have the same report, in power BI It take just few seconds to&nbsp; refresh the pages of the report ( the max is 1 min for a page in the report), but It takes 30 min sometimes in Excel just after changing one filter, sometimes It crushes when a lot of users works on IT.</P><P>&nbsp;</P><P>I know that the Excel is not optimsed like power BI to run a query from SQL server Analysis services database,Is theire any solution to solve this kind of problem because they are sticky to EXCEL?</P><P>&nbsp;</P><P>&nbsp;</P><P>Many thanks in advance for your propositions <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 19 May 2022 17:58:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SLOW-Excel-after-changing-filters/m-p/2527323#M70716 Momie2005 2022-05-19T17:58:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SLOW-Excel-after-changing-filters/m-p/2527419#M70732 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="343197" data-lia-user-login="Momie2005" class="lia-mention lia-mention-user">Momie2005</a>&nbsp;</P><P>This is why I dumped excel. The DAX engine is different in excel than power bi. I don't know the details. However, excel is much more faster in one case, which is when you have a large number of queries. Excal can handle tens of queries while power bi crashes &nbsp;</P> Thu, 19 May 2022 18:54:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SLOW-Excel-after-changing-filters/m-p/2527419#M70732 tamerj1 2022-05-19T18:54:48Z