Import From Excel - Retain Filters

[paulrockliffe]

I have a table in Excel that I want to load into Power Query. The Table is filtered using a few Slicers, is it possible to retain the applied filters when I load the Table into Power Query?

I'm creating a tool that lets me subset a spreadsheet down based on some chosen values, I want to choose those values in my Table then load only those values into Power Query so that I can then merge using an inner join with my other queries so that the same filter selection is applied across my entire Data Model. I've got it all working, apart from getting the the filtered table in.

 

[sandy666]

The Table is filtered using a few Slicers, is it possible to retain the applied filters when I load the Table into Power Query?

afaik, you can't