Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
pooja_martina
Regular Visitor

Cannot connect Mysql database to Power BI.

MySQL 8.0.32

Power BI 2.116.966.0 64-bit (April, 2023)

mysql-connector-net-8.0.32

mysql-connector-odbc-8.0.32-winx64

Windows 11 (64-bit operating system, x64-based processor)

 When I am connecting Power BI, this error is shown. I cannot figure out the issue as I'm using the same version of all the programs. Where am I going wrong?

pooja_martina_0-1694721575368.png

I'm scratching my head over this one. If possible can anyone tell me the specifications of their programs so that I can install the same?

 

1 ACCEPTED SOLUTION
pooja_martina
Regular Visitor

After some trial and error, installing mysql-connector-net-8.0.28.msi helped. Now everything is working fine.

View solution in original post

3 REPLIES 3
pooja_martina
Regular Visitor

After some trial and error, installing mysql-connector-net-8.0.28.msi helped. Now everything is working fine.

amitchandak
Super User
Super User

@pooja_martina , Make sure you have installed latest .net driver

https://dev.mysql.com/downloads/connector/net/

 

IP is whitelisted in Mysql of the desktop system

 

Tried it. Still shows the same error. Can you tell me the specifications of your MySQL and connectors so that I can install them?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.