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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Momie2005
Frequent Visitor

SLOW Excel after changing filters

Hello, 

 

I'm working with a financial team (they love EXCEL😛), and we have the same report, in power BI It take just few seconds to  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.

 

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?

 

 

Many thanks in advance for your propositions 🙂

 

 

 

1 REPLY 1
tamerj1
Super User
Super User

@Momie2005 

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  

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.