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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Nikhi

      Thank you very much it work fine now

      Paul

  • 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