Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI - Sharepoint List connection Issues

Hi

When connecting the Power BI Desktop to a Sharepoint List an error is displayed.

 

Error: Unable to connect

 

We encountered an error while trying to connect.

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request Failed:

OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)"

 

I have checked the sharepoint link several times and it is correct, so I can not understand why I am getting a 404 error.

 

Would you be able to assist me on that ? 

Can you share an example of link to connect to a Sharepoint List or Share the structure that it must have ? 

 

Thank you !

Need Help
  • trebgatte's avatar
    trebgatte
    6 years ago

    You have to log in into the Data Source when you connect. You likely were presented a window and you didn't select Microsoft Account on the left side to log in. Consequently, it's using Anonymous access. 

     

    To fix, in Power BI Desktop, go to

    1. File, Options and Settings, Datasource settings
    2. Select your data connection in the window
    3. Click Clear Permissions
    4. Close the dialog
    5. Click Refresh in the ribbon
    6. You will be prompted to log into the data source
    7. Click Microsoft Account on the left side
    8. Click the Sign In button to enter your credentials
    9. Select the site address in the dropdown
    10. Click Ok or whatever to connect

    You should now see data.

     

    --Treb

     

    Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/

8 Replies

  • trebgatte's avatar
    trebgatte
    Most Valuable Professional
    6 years ago

    You are either putting in the URL for the list instead of the site URL OR you didn't select Microsoft Account and sign in with your O365 credentials when prompted to log into the site.

     

    Thanks!

    --Treb

     

    Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Treb,

       

      Thanks for your reply.

       

      I have tried putting both URL for the list and site, but I have got the error the same way.

      When I set the URL for the list, an error 404 is displayed; 

      When I set the URL for the site, an error is displayed telling me that the URL is not valid.

       

      Also, I have checked that I am signed on both Power BI and Sharepoint accounts.

       

      If you have any other suggestion, that would be great. 

       

      Thank you ! 

      • trebgatte's avatar
        trebgatte
        Most Valuable Professional
        6 years ago

        Is this SharePoint Online?

         

        --Treb