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 have the same error, does somebody find a workaround?
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)