Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
Some extra details about my situation:
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
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