Forum Discussion
mysql append query error
- 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
Hi Anonymous,
What version of Power BI Desktop are you using? It seems to be that you're using an old version. So could you try using the latest version of Power BI Desktop to see if the "Append Queries" works? :smileyhappy:
Regards
v-ljerr-msft hello, I hope you are well, annex the version I am using of power bi, I still can not overcome this problem, I appreciate any help
I have not been able to overcome this difficulty, if someone can help me, I appreciate it very much.
Observing the message that gives power bi I thought that it was the interpretation that makes the connector of the database MySql, (I connect to a MariaDB database), then what I did was uninstall the MySQL connector and install the connector MariaDB, however after this does not allow me the connection and I have no alternative but to reinstall the connector that suggests power bi, which is a .NET connector type
reading on the official page of MariaDB indicate that the same MySQL connector should work, but then at the time of realizing it, the same behavior is presented.I hope this information contributes something to finding the solution.