Slow Refresh after Do Filtering

[asril0427]

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?

[Anonymous · Accepted solution]

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 Learn

2. 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 Team

If 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

[Idrissshatila]

Hello @asril0427 ,

you better remove columns that you don't need from Power query, and this will result a better performance.