Forum Discussion

Oonizuk's avatar
Oonizuk
Copper Contributor
Jul 05, 2024

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

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jul 05, 2024

    Oonizuk 

    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.

Resources