Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Solved! Go to Solution.
Are you removing the Default.aspx or whatever is at the end of the url? It should be https://tenantname.domain.com/sites/sitename
Thanks!
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
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
You should now see data.
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
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/
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 !
Is this SharePoint Online?
--Treb
Yes, it is.
Are you removing the Default.aspx or whatever is at the end of the url? It should be https://tenantname.domain.com/sites/sitename
Thanks!
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
I have got a new error using this format:
- Access forbidden
That's weird because the user actually has access to the Sharepoint.
Does the Power BI require any upgrade on license to connect to Sharepoint List ?
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
You should now see data.
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
It worked
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |