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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.