Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@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_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).
@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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |