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/sites/nom-sharepoint", [ApiVersion = Auto])
Error is :
InnerException0.Stack Trace Message:
La valeur spécifiée est composée de caractères CRLF non valides.
Nom du paramètre : value
The same command line is working with PowerBi Desktop on my computer...
How could I solve my issue please?
Thanks
Sébastien
7 Replies
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?
