How to use PQ keep only SI_TI.CSV ?

[Paulyeo11]

Hi All

I need to create sample file. in the past i go to sharepoint delete all CSV file and keep SI_TI.CSV.This is very slow.

[Anonymous · Accepted solution]

After the file load in Power Query, you can apply a filter to just keep SI_TI.CSV and uncheck others.

[Paulyeo11]

Hi Nikhi

Thank you very much it work fine now

Paul

[mahoneypat]

Earlier in that query (or in the query that feeds it, if applicable), before you expand the Tables with the CSV data, can you just filter on the filename then (instead of after all the data are expanded)?

Pat

[Paulyeo11]

Hi Mahoney

Thank you for sharing , my objective is to create sample file , as SI_TI.CSV is not sensitive data.  the rest of file are sensitive data. 

i want to create a sample file for my PBI file .

Now i am using Keep Row at PQ. 

Paul