Forum Discussion

David_Kaine's avatar
David_Kaine
Frequent Visitor
3 years ago

Power Query loads unfiltered data

Hello everyone,

I have several power query queries that I merged into one.
They are identical queries, but with different data sets.

 

On my merge, I filtered the columns to keep only the results I am interested in.

I did get what I wanted, but when I reload this merges, it also reloads the results outside my filter.

 

Is there a way to reload only the filtered results?

 

I hope to express myself correctly, I remain at your disposal.

 

Thanks to all 😉

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi David_Kaine ,

     

    Please uncheck the 'Enable load' option and the table will not be loaded the next time.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

  • David_Kaine's avatar
    David_Kaine
    Frequent Visitor
    3 years ago

    Hi, thank you for the prompt answer, unfortunately I don't have this option on my tables  😞 

    Power Query Excel (French Version)