Forum Discussion
[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 ...
I experianced this error after exporting from third party, when following one of the comments from above I saw that even though I was selecting to export as an excel it was exporting to Html. I would suggest checking this as a troubleshoot method if anyone experiances this in the future.