Forum Discussion
Virtual_Ames
Microsoft Employee
Microsoft Employee[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 ...
Virtual_AmesMicrosoft Employee
Microsoft EmployeeAnkit,
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
Impactful Individual
Impactful IndividualVirtual_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