ole db or odbc error: [DataFormat.Error] OData: The

Hi everyone and thanks in advance for your help,

I'm having the same error and I'm not able to find a solution. The error appears just for some sharepoint lists, and the refresh run OK for another one, so it looks like should be a problem with the list configuration (format of a field, bad data...)

I thought it might be related to Calculated Fields, but I've discarded that option since a list without those fields failed anyway.

This is the trace I'm getting. I've tried to understand it, but can't find any exceptions there.

DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7108430Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0043369"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7232289Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.1859531"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9092181Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0000787"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9092398Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0001153"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9183152Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":7,"Duration":"00:00:00.0001030"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7232096Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.1922834"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7196222Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.1931997"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9128711Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0111725"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7193559Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"1","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.2047311"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9245153Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000378"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9617099Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0073147"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9690578Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000513"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9778989Z","Action":"SqlTranslator/SqlParser/Parse","SQL":"SELECT * FROM [Logs]","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0016327"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9796941Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000303"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9796842Z","Action":"SqlExpressionTranslator/Translate","IsRecognized":"True","Result":"(database) => Table.RenameColumns(Table.PrefixColumns(database[Logs], \"Logs\"), {{\"Logs.Log File\", \"Log File\"}, {\"Logs.Log File Date\", \"Log File Date\"}, {\"Logs.Level\", \"Level\"}, {\"Logs.Trace Id\", \"Trace Id\"}, {\"Logs.Date\", \"Date\"}, {\"Logs.Action.1\", \"Action.1\"}, {\"Logs.Action.2\", \"Action.2\"}, {\"Logs.Action.3\", \"Action.3\"}, {\"Logs.Action.4\", \"Action.4\"}, {\"Logs.Action.5\", \"Action.5\"}, {\"Logs.Action.6\", \"Action.6\"}, {\"Logs.Action Detail\", \"Action Detail\"}, {\"Logs.ProductVersion\", \"ProductVersion\"}, {\"Logs.ActivityId\", \"ActivityId\"}, {\"Logs.Process\", \"Process\"}, {\"Logs.Pid\", \"Pid\"}, {\"Logs.Tid\", \"Tid\"}, {\"Logs.Duration\", \"Duration\"}, {\"Logs.DbProviderName\", \"DbProviderName\"}, {\"Logs.Exception\", \"Exception\"}, {\"Logs.CommandText\", \"CommandText\"}, {\"Logs.ResponseFieldCount\", \"ResponseFieldCount\"}, {\"Logs.EvaluationId\", \"EvaluationId\"}, {\"Logs.Log Id\", \"Log Id\"}, {\"Logs.Hour\", \"Hour\"}})","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0604325"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:17.0401635Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000459"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9690541Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0715959"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:17.0406693Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000287"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9617025Z","Action":"SimpleDocumentEvaluator/GetResult<IDataReaderSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:09.8263895"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9612307Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0794911"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:17.0407616Z","Action":"RemotePageReader/RunStub","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:10.1056506"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9610941Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"2","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:10.1853333"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:27.1466186Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000984"}