Forum Discussion

Virtual_Ames's avatar
Virtual_Ames
Microsoft Employee
10 years ago

[DataFormat.Error] External table is not in the expected format.

Community,   I am having a problem importing files from a sharepoint folder (6 files that need to be brought together). I see these as .xls files in Sharepoint and therefore use:        let     ...
Need Help
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Virtual_Ames Can you not use in-built sharepoint connector and connect that way ? Maybe it can get rid of that error using in-built connector.

  • Virtual_Ames's avatar
    Virtual_Ames
    Microsoft Employee
    10 years ago

    Ankit,

     

    Thanks - using the SharePoint Folder approach has the same result.

     

    I can see the folder, and see the .xls files. 

     

    However, when I click the Content column to combine binaries, I get the same problem.

     

    (Excel.Workbook(#Combined Binaries) is auto-generated upon clicking the double down arrows in the Content column shown above).

    • augustindelaf's avatar
      augustindelaf
      Impactful Individual
      6 years ago

      Virtual_Ames I have exactly same problem (also xls files from a SharePoint.Files request) !

       

       

      The only solution that I found is to convert those files to .xlsx

      Hope that helps !

       

      Augustin de la Fouchardiere

      MYPE 

      https://www.mype-consulting.com/

    • Andrea's avatar
      Andrea
      Microsoft Employee
      9 years ago

      I have the same error, does somebody find a workaround?

      • przemekkucia's avatar
        przemekkucia
        Advocate II
        9 years ago

        Same error,

         

        In our case it seems that access restrictions create the problem. Even with full control given to me. After removing them it worked like magic. 

         

        Sadly, if files have to be restricted - we haven't found any workaround. (Power Query for Excel also didn't work)