Conection with Mysql DataBase

Hi!
I'm trying to connect my Power Bi desktop to a Mysql database that is on a server on the same network but its not working.
I noticed that if I try to connect selecting only one collum from that DataBase some times it show the preview, but if  I include another collum or try to select every collum it shows one of the following errors, in any case it failed to import database, another thing is that I can connect with another DB from a diferent server from the same network with no problem.

Any Ideas of what might be causing it?

Erro:
"object cannot be cast from dbnull to other types"
"The given Key was not present in the dictionary"