topic Re: Accessing Sharepoint List Error in Power Query

Accessing Sharepoint List Error

Anonymous — Fri, 08 Nov 2019 00:54:13 GMT

Hi Team,

I am tring to access sharepoint page data from Power Bi and getting the follwoing error when I try to connect.

The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'Bearer realm="03b07a97-a58c-4be0-8ad3-d308163f8fa9",client_id="00000003-0000-0ff1-ce00-000000000000",trusted_issuers="00000005-0000-0000-c000-000000000000@*,00000003-0000-0ff1-ce00-000000000000@03b07a97-a58c-4be0-8ad3-d308163f8fa9",NTLM'.

Can someone help me please? Its quite urgent.

Thanks

Re: Accessing Sharepoint List Error

edhans — Fri, 08 Nov 2019 01:33:43 GMT

Did you see this thread? It is old, but same issue.

Re: Accessing Sharepoint List Error

Anonymous — Mon, 11 Nov 2019 00:29:27 GMT

Thanks for the response. Can someone please advise me , How can I access the Sharepoint List as data source from Power BI.

Thanks

Re: Accessing Sharepoint List Error

Anonymous — Mon, 11 Nov 2019 02:00:48 GMT

Hi Anonymous ,

well, like everything else from main menu "Get New Data":

This generates for me the code like below:

let Source = SharePoint.Tables("https://mycompany.sharepoint.com/sites/myteam/", [ApiVersion = 15]), #"Table" = Source{[Id="1cd9225b..."]}[Items], #"Renamed Columns" = Table.RenameColumns(#"Table",{{"ID", "ID.1"}}) in #"Renamed Columns"

A couple of suggestions:

In the import wizard can you get through to see the list of folders? Or it fails before the import wizard completes?
If the wizard fails before the completion, do you think you have access to the Sharepoint site? Maybe try to create and test on a new Sharepoint site? Test if you can access it as Sharepoint folder rather than List?
Are you sure you are using a correct address? It should look like https://mycompany.sharepoint.com/sites/myteam/, not like https://mycompany.sharepoint.com/sites/myteam/Shared Documents/...

Kind regards,

Re: Accessing Sharepoint List Error

Anonymous — Mon, 11 Nov 2019 23:53:50 GMT

Thanks. It fails before the import wizard. I feel like some access issue, I have requested to check my access to the Sharepoint site. I will update how I go.

Thanks

Re: Accessing Sharepoint List Error

Anonymous — Tue, 12 Nov 2019 23:29:51 GMT

I resolved this issue using windows credentials instead of Organisational account credentials.

Thanks