Forum Discussion

piotr_gor's avatar
piotr_gor
Helper II
4 years ago

Why Power Query sees one excel file as error?

Hi there,  I try to connect to sharepoint specific folder, grab all of the files, merge then and do some other stuff with it. I use code as below:  let Source = SharePoint.Files("https://my-com...
Need Help
piotr_gor's avatar
piotr_gor
Helper II
4 years ago

Dataformat.error external table is not in the expected format

piotr_gor's avatar
piotr_gor
Helper II
4 years ago

I found a solution. I mean it's just a workaround but if I open file, don't change anything and save it before uploading on SharePoint it doesn't raise an error.