Hello All,

I have only recently discovered the beauty of PowerQery in excel, but I'm not fully confident with navigation and its functionality yet. I came across an issue that I don't see how to resolve.

I have to run the query in the file with multiple tabs that is feeding from another file and sorting the data import for separate sheets within the spreadsheet as required. Data in the PowerQuery is sorted by specific filtering requirements for each separate tab.

The issue is (in my opinion not really an issue, but I have a request to complete this in a specific way) that each export tab has default (looks like embedded) filters on the top (after I run the PowerQuery). My task is to get rid of these filters.

PQ filter snap.JPG

Is there a way to tell PowerQuerry to export data, but without the embedded filtering or is there a way to de-activate the filtering after the PQ imports the data?

The default options for filtering (after the PowerQuery is completed) are inactive:
PQ filter snap2.JPG


Regards,
L.