Forum Discussion

Virtual_Ames's avatar
Virtual_Ames
Icon for Microsoft Employee rankMicrosoft 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
Virtual_Ames's avatar
Virtual_Ames
Icon for Microsoft Employee rankMicrosoft 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).

Andrea's avatar
Andrea
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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