Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
ksingla96
Frequent Visitor

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

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?

5 REPLIES 5
amitchauhan
Regular Visitor

Was this resolved ? I am having similar issues and not able to fix it. I have tried deleting the credentials as well.  other list in the same site works fine. Just this list wont work. I need to find what is and where it is wrong. Any help in finding the root cause would be helpful.

Eric_Zhang
Microsoft Employee
Microsoft Employee


@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?


@ksingla96

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?

 

Capture.PNG

@Eric_Zhang

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?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.