Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aquarian27
New Member

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?

1 ACCEPTED SOLUTION
hnguy71
Memorable Member
Memorable Member

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



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

3 REPLIES 3
hnguy71
Memorable Member
Memorable Member

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



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

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?

I would recommend saving it first to a local drive and then try your shot at uploading it to your SharePoint site. 



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.