Why doesn't my filtered table show as filtered in query editor when using get & transform?

[uysal5]

I have multiple workbooks with each one filtered to show different data. I now need to combine them but when I use get and transform, the tables are ignoring the filters and showing the data without any filters applied.

What am I doing wrong?

Thank you
Figen

 

[Guenther45]

Hello Figen,
imho: I think you're not doing anything wrong. Power Query (Get & transform) reads the unfiltered data or imports it.


But you can set a marker in the source data in an auxiliary column, which can then be evaluated by Power Query for filtering.


greetings
Guenther

 

[uysal5]

Thank you I will try

 

[Hashiru]

Hi uysal5,

You can copy the filtered data into a worksheet or do the filter in Power Query.