Selecting more than one excel in in folder in PowerQuery for Excel Causes and Error after Combining the Binaries Get & Transform From File From Folder Select more than one file let Source = Folder.Files("C:\Users\USERNAME\Documents\EXCEL\Test"), #"Combined Binaries" = Binary.Combine(Source[Content]), #"Imported Excel" = Excel.Workbook(#"Combined Binaries") in #"Imported Excel" Results in DataFormat.Error: External table is not in the expected format. Details: pwvk2cn5.XLS
3 Comments
- Hello David, I am able to get your M query to run on my computer...See below. Perhaps you have one of the files open? Thanks Chuck let Source = Folder.Files("C:\uv"), #"Combined Binaries" = Binary.Combine(Source[Content]), #"Imported Excel" = Excel.Workbook(#"Combined Binaries") in Source
- Closing as answered
- Status added:Completed
