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

    sadf sdf 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

    sadf sdf 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