Forum Discussion
Excel Refresh
I have a datamodel connected into Excel as my users only are familiar with that and wont change to leveraging PowerBI. When I use the Analzye in Excel function or connect to the Data Model from Power...
Hi MikeOrozco ,
Based on the description of your problem, it seems like the refresh time is significantly impacted when interacting with complex filters and pivot tables. May I ask if you have tried to optimize the data?
- Ensure that the measures created in Power BI (and subsequently used in Excel) are optimized for performance. This includes avoiding complex calculations that can be simplified or pre-calculated within Power BI before being imported into Excel.
- While filters are essential for drilling down into data, excessive use, especially in combination, can significantly slow down refresh times.
- Slicers can sometimes offer a more performance-efficient way to filter data in pivot tables. They are especially useful when dealing with a large number of items to filter.
More details: Optimization guide for Power BI - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.