Forum Discussion

David Kibler's avatar
David Kibler
Copper Contributor
Aug 15, 2017

Unable to use Power Query to Connect to a Sharepoint List

I'm trying to import a SharePoint list in via PowerQuery.  When I try to use the root folder (and any variation there of) with my windows credentials I get an error: 400, Bad Request.   I've tried...
excel
Get & Transform
power bi
Power Query SharePoint Lists
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 16, 2017

Hi David,

 

Am i correct that's on-premises Sharepoint? For my knowledge SPO URL structure looks like <yourdomain>.sharepoint.com/sites (or /teams, or /search). Or for HP that's customized structure?

 

Anyway, for SPO list Organizational (Microsoft) account shall work, same with which you login to O365.

For Sharepoint on-premises works Windows account as in Active Directory.

 

And your root URL you use to connect is to be .../teams/TSPO

 

In menu there are two connectors, on Sharepoint Online List and on Sharepoint List, but actually both shall work.

  • Evgeny_Kazakov's avatar
    Evgeny_Kazakov
    Copper Contributor
    May 07, 2020

    SergeiBaklan 

    Hi Sergey,

    I have a similar question: connecting to the site I've selected anonymous access.

    I do not see how I can change this option. Excel remembers the 1st setting and does not ask for the type of credentials.

     

    Thanks, Evgeny

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 08, 2020

      Evgeny_Kazakov 

      Evgeny,

      Data->Get Data->Data Source settings

      Here select your source and edit permissions

Resources