Forum Discussion
Problem in connecting Sharepoint List to Power BI
When I try to connect Sharepoint List in Power BI, I get following error:
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)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"
What is the solution to resolve this issue?
Are you trying to access the list through OData feed or using the SharePoint list connector?
If through OData feed, http://siteurl/_vti_bin/ListData.svc/data_to_be_fed
If through SharePoint list connector, make sure you're only choosing up to the site url and not the actual list, ie, http://root.sharepoint.com/sites/yoursite/
From there, expand your list
3 Replies
hnguy71Super User
Are you trying to access the list through OData feed or using the SharePoint list connector?
If through OData feed, http://siteurl/_vti_bin/ListData.svc/data_to_be_fed
If through SharePoint list connector, make sure you're only choosing up to the site url and not the actual list, ie, http://root.sharepoint.com/sites/yoursite/
From there, expand your listThanks Hnguy71
Now I am facing another issue. When I try to save the Power BI file to my sharepoint site, I got following error:
"Access Denied. Before open file in this location, you must first add the web site to your trusted site list, browse to web site and
select the option to login autometically".
My site has already been in trusted location and I selected the option of login autometically, but still I am facing this error.
Can you help me in this also?
- hnguy71
I would recommend saving it first to a local drive and then try your shot at uploading it to your SharePoint site.
