Forum Discussion

bigdatakev's avatar
bigdatakev
Frequent Visitor
3 years ago
Solved

Need to optimize filters

I have a large dataset that contains roughly 7 million rows with about 16,000 distictive results. The dataset contains entries (rows) that do not provide value to the dashboard and need to be exclude...
Tips and Tricks
  • vicky_'s avatar
    vicky_
    3 years ago

    Could you consider filtering them out using Power Query - specifically the filtering by values? This would be an option if you have access to the data source. This would be faster than the page-level filters as the irrelevant data is processed before it reaches the dashboard. Check out the official Docs here to get started: https://learn.microsoft.com/en-us/power-query/filter-values

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

Could you consider filtering them out using Power Query - specifically the filtering by values? This would be an option if you have access to the data source. This would be faster than the page-level filters as the irrelevant data is processed before it reaches the dashboard. Check out the official Docs here to get started: https://learn.microsoft.com/en-us/power-query/filter-values

bigdatakev's avatar
bigdatakev
Frequent Visitor
3 years ago

Thank you this worked for me!