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/...
excel
Oonizuk's avatar
Oonizuk
Copper Contributor
Jul 08, 2024

I already tried the API version (14, 15, 'Auto', Auto,...) but I got the same result :sad:

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 08, 2024

Oonizuk 

14 doesn't work, did you try 15?

  • Oonizuk's avatar
    Oonizuk
    Copper Contributor
    Jul 08, 2024
    yes but same result...
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 08, 2024

      Oonizuk 

      Could you please indicate is that SharePoint Online or on-premises and on which Excel platform/version you are?

      • Oonizuk's avatar
        Oonizuk
        Copper Contributor
        Jul 09, 2024
        My company deployed Office 365
        SharePoint in Microsoft 365 (= SharePoint Online)
        Microsoft® Excel® for Microsoft 365 MSO (Version 2406 Build 16.0.17726.20078) 64 bits

Resources