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 PowerBI it works as it is intended, however where I am running into issues is with the constant need for the model to continiously refresh when my users are leveraging multiple filters with pivots leveraging measures created from PowerBI. When this happens it looks like it is consistently refreshing the data model. I've turned off all of the refresh options within the query but I can't seem to get passed this. Each time the data loads its taking close to 30-60 seconds to refresh its connection to the model. Any help or recommendations on alternative solutions to this is appreciated!!
1 Reply
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
