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. 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

 
 
 
 
 
 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

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

    Thanks

     

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

      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