Forum Discussion
Slow Refresh after Do Filtering
Hi All, I have raw data for dashboard by uploading from CSV File. The data size is 230 columns and 1.5 M rows. I want to filter using tools from visualizations menu. I want to know why the refreshing is slowly after I do filter?
Hi, asril0427
Thanks for Idrissshatila reply. Here is additional content about data optimization.1. Review your data model for any unnecessary columns that you could remove. Reducing the number of columns can decrease the amount of data processed during refreshes.
Optimization guide for Power BI - Power BI | Microsoft Learn2. Filtering data using combinatorial filtering.
Power BI: How to Improve Refresh Speed (antaresanalytics.net)
3. If possible, create summary tables that aggregate the data to a higher level. This can reduce the volume of data needed for your visualizations and, as a result, improve refresh performance. You can then use drill-through features to access more detailed data as needed.Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hello asril0427 ,
you better remove columns that you don't need from Power query, and this will result a better performance.
Hi, asril0427
Thanks for Idrissshatila reply. Here is additional content about data optimization.1. Review your data model for any unnecessary columns that you could remove. Reducing the number of columns can decrease the amount of data processed during refreshes.
Optimization guide for Power BI - Power BI | Microsoft Learn2. Filtering data using combinatorial filtering.
Power BI: How to Improve Refresh Speed (antaresanalytics.net)
3. If possible, create summary tables that aggregate the data to a higher level. This can reduce the volume of data needed for your visualizations and, as a result, improve refresh performance. You can then use drill-through features to access more detailed data as needed.Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
