Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to use PQ keep only SI_TI.CSV ?

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.    
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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