Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
What's the version of your MySQL driver?