Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

mysql append query error

  good afternoon master I hope everything goes well for you, again I have to bother you with a question. I'm connecting power bi to a MySql database, the tables are raised correctly, but at the ti...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago
    I still do not know the main cause of this error, but the solution is once the necessary transformations are made, in the attached query change the name of the columns, then load correctly, I hope this can be useful to other people. Thank you
Anonymous's avatar
Anonymous
Not applicable
8 years ago

hi aarola

If the error you have is the same that appears in the attached screens what I did was to make the append of the tables in power query
naturally for these to be loaded if they come from different systems have to have the same column name
After they are merged correctly you change the name to the identifier of the column and it should work
apparently it is a topic related to language I suggest you look at the regional configuration of the machine
I hope to be helpful

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have the same issue with an uptodate version. 

In my case I can make it works with 2 tables but when I add 3rd table I get the same error as you. 

Where did you change the column name ? In the original table or in the new table created after the append ? 

 

Thanks for your help

gaful