web
You’re offline. This is a read only version of the page.
close
Skip to main content

    Issues

    Completed

    Bug Combining Binaries In PowerQuery for Excel

    Vote (1) Share
    David Pitts's profile image

    David Pitts on 10 May 2016 05:04:38

    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

    Comments (2)
    David Pitts's profile image Profile Picture

    ac643e7c e800-ea11-a811-000d3a4f1ebb on 05 Jul 2020 22:25:47

    RE: Bug Combining Binaries In PowerQuery for Excel

    Closing as answered

    David Pitts's profile image Profile Picture

    ac643e7c e800-ea11-a811-000d3a4f1ebb on 05 Jul 2020 22:23:19

    RE: Bug Combining Binaries In PowerQuery for Excel

    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