Hello all,
I have 3 tables from the same database. I have merged them through the editor, and it was fine for the longest time.
For some reason, I started getting this error and the scheduled refresh always fails now. I do not recall changing anything on my side so this is baffling. The db is provided by a 3rd party, so I am not sure if they changed something in the table, but I can not tell just by this error.
Any help is appreciated.
{
"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": "MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\r\n union all select `_`.`accnt_type` as `accnt_type`,\r\n `_`.`descript' at line 323"
}
},
{
"code": "DM_ErrorDetailNameCode_UnderlyingHResult",
"detail": {
"type": 1,
"value": "-2147467259"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.DataSourceKind",
"detail": {
"type": 1,
"value": "MySql"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.DataSourcePath",
"detail": {
"type": 1,
"value": "mksdb.com*******.amazonaws.com;views"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.ErrorCode",
"detail": {
"type": 1,
"value": "-2147467259"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.Message",
"detail": {
"type": 1,
"value": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\r\n union all select `_`.`accnt_type` as `accnt_type`,\r\n `_`.`descript' at line 323"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.Reason",
"detail": {
"type": 1,
"value": "DataSource.Error"
}
}
],
"exceptionCulprit": 1
}
}
} Table: Balances.
