Problem in connecting Sharepoint List to Power BI

[Aquarian27]

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?

[hnguy71 · Accepted solution]

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

[Aquarian27]

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