Forum Discussion
ole db or odbc error: [DataFormat.Error] OData: The
ksingla96 wrote:
ole db or odbc error: [DataFormat.Error] OData: The format 'application/json;charset=utf-8' is not supported.. error when trying to refresh the report?
What is the datasource in your case? Do you get the error when clicking "refresh" button in Power BI desktop. Could you enable trace, reproduce the error and upload the log file?
The data source is Sharepoint lists and yes the error occurs after clicking 'refresh' button
DataMashup.Trace Information: 24579 : {"Start":"2017-06-19T05:03:13.0486318Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","HostProcessId":"9116","Exception":"Exception:\r\nExceptionType: System.IO.IOException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The process cannot access the file 'C:\\Users\\dell\\AppData\\Local\\Temp\\Power BI Desktop\\1bd8f44d-d832-46d8-9a51-5edb85b9848a\\Caches\\0b820d1e-d39b-4f96-9ceb-a5648de724ee\\a44c0631-7945-45ef-9fa1-0851e16feda7.dat' because it is being used by another process.\r\nStackTrace:\n at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n at System.IO.File.InternalDelete(String path, Boolean checkHost)\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass4.<IgnoringAccessExceptions>b__3()\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, IEvaluationConstants evaluationConstants, T& result, Exception& accessException)\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":10,"Duration":"00:00:00.0029686"}
DataMashup.Trace Error: 24579 : {"Start":"2017-06-19T05:03:12.9252151Z","Action":"Engine/IO/OData/GetResponse","HostProcessId":"9116","RequestUri":"http://apps.mydrreddys.com/sites/gg/OCMS/_vti_bin/ListData.svc/Observation?$select=ApplicableUnits,B...: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\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.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.2951614"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-06-19T05:03:12.8959829Z","Action":"Library/Common/RetryPolicy/TryExecuteAction","HostProcessId":"9116","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: (400) Bad Request.\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.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3250264"}
DataMashup.Trace Error: 24579 : {"Start":"2017-06-19T05:03:12.8959074Z","Action":"Library/Common/RetryPolicy/ExecuteAction","HostProcessId":"9116","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: (400) Bad Request.\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.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3253228"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-06-19T05:03:12.8948810Z","Action":"Engine/IO/OData/GetResponseStream","HostProcessId":"9116","ResourceKind":"SharePoint","RequestUri":"http://apps.mydrreddys.com/sites/gg/OCMS/_vti_bin/ListData.svc/Observation?$select=ApplicableUnits,B...: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\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 at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream(IHostTrace trace, String key)\r\n\r\n\r\n","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: (400) Bad Request.\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 at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream(IHostTrace trace, String key)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream()\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3267592"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-06-19T05:03:12.8946927Z","Action":"Engine/IO/OData/CreateResult","HostProcessId":"9116","RequestUri":"http://apps.mydrreddys.com/sites/gg/OCMS/_vti_bin/ListData.svc/Observation?$select=ApplicableUnits,B...: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\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 at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream(IHostTrace trace, String key)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream()\r\n at Microsoft.Mashup.Engine1.Library.OData.V3.Http.GetResult(Uri uri, ODataEnvironment environment)\r\n at Microsoft.Mashup.Engine1.Library.OData.V3.RequestInfo.RequestResult()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataFallbackVersionHandler.HandleVersionFallback[T](Func`1 function, Boolean throwOnBadRequest)\r\n at Microsoft.Mashup.Engine1.Library.OData.V3.RequestInfo.CreateResult()\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3274921"}
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"}Has this been resolved? Do you have a work around?
