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 ...
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)
I'm trying to access a JetReport .xlsx shared to me from a Sharepoint site
It also fails with "External table is not in the expected format"
Any one had experience with using shared excel files in PowerBI?