powerquery filtering data in import time
When you're loading the data, click 'Transform Data', as shown above.
In the PowerQuery Editor, filter column1 for the required value:
Click 'Close & Load' and your filtered data will be loaded into the spreadsheet:
