Unable to connect to SharePoint list error Details: "SharePoint: Request failed:<br>OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)<br>OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)<br>OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)" The list is a very simple list that I setup in order to test Power BI. It only has 3 fields.All fields have data.

Hi John When trying to connect to the list are you using the full URL of the list, or just linking to the site URL? i had a similar problem which was caused by trying to link to the full list address. See thread:http://community.powerbi.com/t5/Service/PowerBI-linked-to-SharePoint-Lists-require-a-Personal-Gateway/m-p/6759#M3329

Connecting to a SharePoint List Office 365 error

16 Replies

Anonymous
Not applicable
4 years ago
While connecting file to power bi, It is intutive to try sharepoint option but instead of that use web option. It worked for me.
GrahamKnowles
Resolver I
10 years ago
Hi John

When trying to connect to the list are you using the full URL of the list, or just linking to the site URL?

i had a similar problem which was caused by trying to link to the full list address.

See thread:
http://community.powerbi.com/t5/Service/PowerBI-linked-to-SharePoint-Lists-require-a-Personal-Gateway/m-p/6759#M3329
- cgil
  Advocate I
  5 years ago
  Hi all!!
  
  I found the solution!!!!!!💪
  
  You just need to copy the URL until your principal Folder tree ( for example: sharepoint/sites/demo)
  Once you are connected you hace to clock on transform data, and you will see all the documents you have on your sharepoint.
  
  Then you have to filter by the document you want to change and after that you have to click on binary on the content column.
  After that you need to click on Table to import the data in to Power BI.
  
  There you have a video to explain it propertly :
  - patkang
    Helper I
    5 years ago
    cgil It was getting quite frustrating but thanks to your tipp it worked perfectly, thanks a lot for sharing!
- cgil
  Advocate I
  5 years ago
  Hi all!!
  
  I found the solution!!!!!!💪
  
  You just need to copy the URL until your principal Folder tree ( for example: sharepoint/sites/demo)
  Once you are connected you hace to clock on transform data, and you will see all the documents you have on your sharepoint.
  
  Then you have to filter by the document you want to change and after that you have to click on binary on the content column.
  After that you need to click on Table to import the data in to Power BI.
  
  There you have a video to explain it propertly :
- MarcNavarro
  Regular Visitor
  10 years ago
  I have this error trying to acces from Power BI to the list or to the directory for this link from sharepoint: https://myxyzsite.sharepoint.com/_vti_bin/listdata.svc
  When i acces using IE i get the xml code from the list.
  
  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. (Resource not found for the segment '_api'.) OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.) OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.)"
  
  Any idea?
  Thanks.
Anonymous
Not applicable
3 years ago
Hey everyone, my colleague had initially linked to the direct sharepoint file link. It was working fine, til only recently (after 1 year), the error came up.

I realized he had used to connect directly to the sharepoint excel file link:
'Source'
=Excel.Workbook(Web.Contents("https://xxx.sharepoint.com/sites/xxx/Shared%20Documents/General/xxx%20Dashboard%20Power%20BI/xxx.xlsx"), null, true)

Strangely once I tried to log in to my credentials and tried to troubleshoot and relink the website, it works. Hence, it seems that linking to the sharepoint file weblink directly using Web.Contents works?

Appreciate if anyone knows if this is the correct method, or linking via sharepoint folder would be better.
Thank you!
Onyeka
Regular Visitor
8 years ago
I have tried incessantly to connect to a particular file located on a sharepoint teamsite., without success. The system guides me
- Pateen
  Helper I
  7 years ago
  Hi There,
  
  I have gotten the same error message when trying to connect to a folder in sharepoint so I can connect to a CSV source data.
  
  The message I get is:
  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)"
  
  Any ideas?
  - JoeRobert06
    Helper II
    7 years ago
    I am having this same problem. I am using SPO as the data connector and reducing the URL path to only show the file (excel sheet) yet I am seeing this same message. Any assistance would be greatly appreciated.
    
    As an alternative, i can use the "website" data connector and gain connectivity with the same URL path. However I am trying to see if I can schedule automatic refreshes off-premise and the website data connector is not allow me to do this.