Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Accessing Sharepoint List Error

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. He...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

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

    Thanks

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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:

  1. In the import wizard can you get through to see the list of folders? Or it fails before the import wizard completes?
  2. 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?
  3. 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,

JB

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    Thanks