daverpitts's avatar
daverpitts
Advocate I
10 years ago
Status:
Completed

Bug Combining Binaries In PowerQuery for Excel

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
power bi

3 Comments

  • chass's avatar
    chass
    Impactful Individual
    6 years ago
    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

Recent ideas