Dataset refresh failure in Power BI service

[Anonymous]

Hello All,

User is getting dataset refresh failure with the below error message. Sometimes it's failed to refresh but not everytime. Can anyone suggest what will be the solution for refresh issue.

Data source error:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft SQL: JSON text is not properly formatted. Unexpected character 'n' is found at position 0."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"16"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"bsr.prod.ntv.com;BSR"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"JSON text is not properly formatted. Unexpected character 'n' is found at position 0."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"13609"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"1"}}],"exceptionCulprit":1}}} Table: Audit_Old.

Thanks in advance!

[arvindsingh802]

It look like for table Audit_Old, the source JSON file is not correctly formatted.
While using file as source, you need to make sure it has correct format to have consitent refreshes.