Forum Discussion

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

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

Diamond Contributor

May 08, 2020

Evgeny_Kazakov

Evgeny,

Data->Get Data->Data Source settings

Here select your source and edit permissions