Forum Discussion

Virtual_Ames's avatar
Virtual_Ames
Microsoft 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
przemekkucia's avatar
przemekkucia
Advocate II
9 years ago

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)

Krishna09's avatar
Krishna09
Helper III
3 years ago

hi ,

how to remove access restrictions?

I am facing same error. In my case i have power automate flow. this flow creates .xls file everey day in sharepoint. 

and trying to connect to power query with schduled refresh.

but when I open xls file in browser and try to change from read to edit, it asks if it can be converted.

so i think if I can save file editable then there will be no issues.

so can any one guide me either how to remove access restrictions or save editable file in sharepoint with power automate flow?