Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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

  1. #1
    New Member
    Join Date
    Sep 2013
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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


    Why doesn't my filtered table show as filtered in query editor when using get & transform?
    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

  2. #2
    New Member
    Join Date
    Nov 2017
    Location
    Hamburg, DE
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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

  3. #3
    New Member
    Join Date
    Sep 2013
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Thank you I will try

  4. #4
    Board Regular
    Join Date
    May 2011
    Location
    United States of America, Maryland, Riverdale
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Hi uysal5,

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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •