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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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