Forum Discussion

Aquarian27's avatar
Aquarian27
New Member
7 years ago
Solved

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 re...
Need Help
  • hnguy71's avatar
    hnguy71
    7 years ago

    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's avatar
Aquarian27
New Member
7 years ago

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's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

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