Filtering Data in Power BI

user_9628339 0
Viewed 126

What happens when I filter data in Power BI data?

I am connecting to Analysis Services and loading data from a cube and then filtering it on the Year column = "2022".

What happens to previous years' data? While the historical data is not used for the report will it cause performance issues to load all the data from the source or does filtering restricts data load to only the filter criteria?

powerbi
1 Answers

Depends where you have filtered.

  • If you filter the other years out in power query, you'll only get 2022 in Power BI. This may affect import time a little bit.
  • Power BI itself is working with subsets. If you're using a page filter for the year 2022, it creats a subset, containing only the 2022 rows. So the other years won't affect the performance. But the file will get bigger and maybe opening lasts a bit longer compared with filtering them out in power query. Advantage: On other pages you still have the full dataset including the years before 2022.
user_122426250
Related