Forum Discussion
Sharepoint access with Excel Powerquery
Hello, I've got an error when I tried to get access to a Sharepoint file via Excel PowerQuery with the command line below Source = SharePoint.Files("https://nom-domaine.sharepoint.com/...
Try with [ApiVersion = 15] , perhaps with Auto Power Query wrongly defines ApiVersion for non-English sites. From documentation:
When Auto is specified, the server version will be automatically discovered if possible, otherwise version defaults to 14. Non-English SharePoint sites require at least version 15.
By the way, in my case it works as [ApiVersion = "Auto"], not as [ApiVersion = Auto]. Server automatically returns 15.
Power Query could have bit different implementation of connectors/functions for Power BI Online, Power BI Desktop and Excel. Usually Power BI ones are bit more advance if difference exists.
I already tried the API version (14, 15, 'Auto', Auto,...) but I got the same result
14 doesn't work, did you try 15?
- yes but same result...
