Forum Discussion
Dataset refresh failure in Power BI service
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!
1 Reply
- arvindsingh802
Community Champion
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.
