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
hewittj
Regular Visitor

SharePoint OLE DB

This is the latest of many cryptic error messages that come from an attempt to connect to a SharePoint List.  Does anyone have any advice for these? 

 

SharePoint Connect Problem 2.PNG

 

 

SharePoint Connect Problem 1.PNG

5 REPLIES 5
v-yuezhe-msft
Employee
Employee

Hi @hewittj,

Do you connect to SharePoint Online list from Power BI Desktop?

If that is the case, regarding to the first error, please go to File -> Options and settings -> Options -> Diagnostics and click "enable tracing", then connect to SharePoint Online list and check the detailed logs in the traces folder. Also please help to post the detailed logs here.

Regarding to the second error, it could occur when your list has Multiple values in a field such as Multiple choices, you can fill these null values or disable allow multiple selection to solve it. Another cause could be that there are lookup fields or calculated columns in your list, please check potential issues with them, here is an similar thread for your reference.

In addition, try to connect to SharePoint Online list via Get Data>OData Feed entry in Power BI Desktop and check if it is successful.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Some extra details about my situation:

  • I'm trying to connect to 5 SharePoint lists.  4 connect ok.  List #5 is the really important one, and that's the one I cannot connect to.
  • I can connect to it through Microsoft Access.  But I still cannot trick Power BI into using the Access connection.
  • All the lists include lookup fields and calculated fields.  Lists 1-4 connect ok.  I see nothing unusual about the Lookup fields and Calculated fields in List 5.
  • List 5 is different in that it has two Multiple choice fields. However, neither field allows multiple choices.
  • Tracing produced three .LOG files.  The opening content of file #1 follows below:

Microsoft.Mashup.Container.NetFX40.4400.2016-08-22T14-45-11-230830.log

 

DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:11.2362664Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":10,"Duration":"00:00:00.0150599"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:11.7892883Z","Action":"Engine/IO/OData/Request","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.0000179"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:11.8102486Z","Action":"Engine/IO/OData/GetResponse","RequestUri":"http://mySharePoint URL/_api/web/lists","RequestMethod":"GET","ResponseUri":"http://mySharePoint URL/_api/web/lists","ResponseStatusCode":"OK","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.2387587"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:11.7892443Z","Action":"Library/Common/RetryPolicy/TryExecuteAction","Attempt":"1","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.2597892"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:11.7438993Z","Action":"Library/Common/RetryPolicy/ExecuteAction","TryCount":"3","RetryAlgorithm":"ExponentialBackoff","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.3051415"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:11.7411950Z","Action":"Engine/IO/OData/GetResponseStream","ResourceKind":"SharePoint","RequestUri":"http://mySharePoint URL/_api/web/lists","ContentType":"application/json;odata.metadata=minimal;q=1.0,application/json;odata=minimalmetadata;q=0.9,application/atomsvc+xml;q=0.8,application/atom+xml;q=0.8,application/xml;q=0.7,text/plain;q=0.7","ThrowOnBadrequest":"True","ResponseContentLength":"-1","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.3080548"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.1026812Z","Action":"Engine/IO/OData/Request","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.0000089"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.1233807Z","Action":"Engine/IO/OData/GetResponse","RequestUri":"http://mySharePoint URL/_api/web/lists","RequestMethod":"GET","ResponseUri":"http://mySharePoint URL/_api/web/lists","ResponseStatusCode":"OK","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.1599160"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.1026556Z","Action":"Library/Common/RetryPolicy/TryExecuteAction","Attempt":"1","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.1806603"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.1026243Z","Action":"Library/Common/RetryPolicy/ExecuteAction","TryCount":"3","RetryAlgorithm":"ExponentialBackoff","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.1807005"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.1019372Z","Action":"Engine/IO/OData/GetResponseStream","ResourceKind":"SharePoint","RequestUri":"http://mySharePoint URL/_api/web/lists","ContentType":"application/json;odata.metadata=minimal","ThrowOnBadrequest":"True","ResponseContentLength":"-1","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.1814531"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.3399891Z","Action":"Engine/IO/OData/GetResponseStream","ResourceKind":"SharePoint","RequestUri":"http://mySharePoint URL/_api/web/lists","ContentType":"application/json;odata=minimalmetadata;q=1.0,application/atomsvc+xml;q=0.8,application/atom+xml;q=0.8,application/xml;q=0.7,text/plain;q=0.7","ThrowOnBadrequest":"True","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.0023993"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.3442131Z","Action":"Engine/OData/ODataUri/TryParseODataUri","ServiceUri":"http://mySharePoint URL/_api/","QueryUri":"http://mySharePoint URL/_api/web/lists","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.0000607"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.3442961Z","Action":"Engine/OData/ODataUri/TryParseODataUri","ServiceUri":"http://mySharePoint URL/_api/web/","QueryUri":"http://mySharePoint URL/_api/web/lists","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.0000307"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.3443483Z","Action":"Engine/OData/ODataUri/TryParseODataUri","ServiceUri":"http://mySharePoint URL/_api/web/","QueryUri":"http://mySharePoint URL/_api/web/lists","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.0000290"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-22T14:45:12.3451244Z","Action":"Engine/IO/OData/Request","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.0000106"}
DataMashup.Trace Error: 24579 : {"Start":"2016-08-22T14:45:12.3653808Z","Action":"Engine/IO/OData/GetResponse","RequestUri":"http://mySharePoint URL/_api/web/$metadata","RequestMethod":"GET","Exception":"Exception:\r\nExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (404) Not Found.\r\nStackTrace:\n   at System.Net.HttpWebRequest.GetResponse()\r\n   at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n\r\n\r\n","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.1384904"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-08-22T14:45:12.3451000Z","Action":"Library/Common/RetryPolicy/TryExecuteAction","Attempt":"1","Exception":"Exception:\r\nExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (404) Not Found.\r\nStackTrace:\n   at System.Net.HttpWebRequest.GetResponse()\r\n   at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n   at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)\r\n   at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.<>c__DisplayClass1.<GetResponseStream>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)\r\n\r\n\r\n","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.1755254"}
DataMashup.Trace Error: 24579 : {"Start":"2016-08-22T14:45:12.3450756Z","Action":"Library/Common/RetryPolicy/ExecuteAction","TryCount":"3","RetryAlgorithm":"ExponentialBackoff","Exception":"Exception:\r\nExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (404) Not Found.\r\nStackTrace:\n   at System.Net.HttpWebRequest.GetResponse()\r\n   at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n   at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)\r\n   at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.<>c__DisplayClass1.<GetResponseStream>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)\r\n\r\n\r\n","ProductVersion":"2.37.4464.361 (PBIDesktop)","ActivityId":"a4df8fdf-d7bd-4d10-87bf-1e870772eb92","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4400,"Tid":1,"Duration":"00:00:00.1758355"}

Hi @hewittj,

Firstly, according to above log file, I note that you are not using the latest version of Power BI Desktop(2.37.4464.602), please firstly download it from this link, install it and connect to SharePoint Online list from it.

Secondly, when you connect to SharePoint Online list, make sure that you use Get Data>Online Services>SharePoint Online List entry in Power BI Desktop.

Thirdly, regarding to the error “The remote server returned an error: (404) Not Found”, I would recommend you use Fiddler to monitor the Http traffic between Power BI Desktop and SharePoint, and check what is going on in the background.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Still not working.

Version 2.37.4464.602 installed.  Same result.  I tried connecting through both "SharePoint Online List" and "SharePoint List". 

Hi @hewittj,

Have you used Fiddler to capture traces?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Top Solution Authors
Top Kudoed Authors