Forum Discussion
JoachimSA
Helper II
Helper IIWeb connector for Excel file on sharepoint
HI everybody, I use the web connector to import data from an excel file stored on sharepoint (I remove the "?web=1" part at the end of the link) Every once in a while when I work on the import...
KNP
Super User
Super UserI'm not sure about the cause of the error but I'd recommend using the SharePoint.Files() connector.
I think it will perform at least as well as and may not suffer the same issues.
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-files
- JoachimSA
Hi KNP,
Thanks for the suggestion.
I tried it with the Sharpoint.files connector - did not work. Also the import requires this convoluted proces with extracting sample data etc (see picture -sorry for the German, maybe you get the point anyways ;-))
What does help is saving without applying the Power Query chances and then closing and reloading the PBIX file....looks buggy to me...
