Forum Discussion

KimS1231's avatar
KimS1231
Frequent Visitor
4 years ago
Solved

Need help with reading files in a folder

I'm trying to pull specific data from cells in excel workbooks. However, in the folder is a system file called thumbs.db. I cannot delete this as it says it is in use. No matter how I try to filter t...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    You should replace this line 

    #"Filter for xlsx files only" = Table.SelectRows(#"Filter out .tmp & .db files", each [Extension] = ".xlsx"),

    with

    #"Filter for xlsx files only" = Table.SelectRows(Source, each [Extension] = ".xlsx"),

  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi KimS1231 ,

    thumbs.db are hidden files created when using thumbnail previews for folders in File Explorer.

     

    If you can confirm that the query has filtered the xlsx files in Power Query, you can try to delete the file by the following articles and check it again:

    How to delete network folder with thumbs.db file on Windows 10 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi KimS1231 ,

thumbs.db are hidden files created when using thumbnail previews for folders in File Explorer.

 

If you can confirm that the query has filtered the xlsx files in Power Query, you can try to delete the file by the following articles and check it again:

How to delete network folder with thumbs.db file on Windows 10 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.