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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jeronimo2334
Helper III
Helper III

Mashup Error Tables Union

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.
1 ACCEPTED SOLUTION
jeronimo2334
Helper III
Helper III

@Greg_Decklerit appears that one of the columns had an underscore in one of the rows so when I used the append tables option, it broke.

Would be nice if the append tables option ignored symbols when the column is of a string type (ABC).

View solution in original post

2 REPLIES 2
jeronimo2334
Helper III
Helper III

@Greg_Decklerit appears that one of the columns had an underscore in one of the rows so when I used the append tables option, it broke.

Would be nice if the append tables option ignored symbols when the column is of a string type (ABC).

Greg_Deckler
Super User
Super User

@jeronimo2334 - From the error, it is indicating an issue with MySQL syntax, specifically I would check to see if the accnt_type column has been renamed?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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