Reputation: 41

Power BI missing MySQL Connector, even though I installed it

On my Windows 10, I downloaded Power BI today in order to pull data from my remote server, which is MySQL.

I go to "get data from other source", choose MySQL, and then get a prompt that "this connector requires one or more additional components to be installed before it can be used"

I installed both the latest NET and ODBC connector for windows, restarted my pc, but still get the same error.

How should I troubleshoot this? Am I supposed to see something running in "services"?

Upvotes: 4

Answers (8)

Mr. Cap.

Reputation: 11

It is a version conflict of MySQL-connector-net.

I was also facing the same issue, I tried it with many latest versions, but failed to connect.

Then I downgraded to the previous version of MySQL-connector-net, which was of 15 MB size, then I was able to connect Power BI with MySQL Database.

I used database credentials for connecting to the MySQL Database.

Upvotes: -1

Adam Huang

Reputation: 29

It might be caused by the installation of the latest version of the connector, like 8.0.29 or above.

To fix it:

Uninstall the newer version by double-clicking on the downloaded file of the connector, selecting "uninstall"
Note: all you need to do is keep the latest version of MySQL, only uninstall the connector.
Install the older version:
Download version 8.0.28 from https://downloads.mysql.com/archives/c-net/ and run the file.
Note: only install connector.
During installation, select the "typical" option.
Restart your computer:
Close Power BI and restart your entire system to ensure the changes are applied. Note that version 8.0.28 is currently the standard version, and it is recommended to use the typical option during installation.

Upvotes: 1

tj001

Reputation: 1

I resolved it by simply installing sql connector and re-launching power bi.

Upvotes: -1

juanm55

Reputation: 1699

As of 4th July 2023, and from this website: LINK

It seems that we need to use version 8.0.26 .

Seems like you can donwload past versions from here

However I must say that apparently the current version will work for me (8.0.33), I am just waiting for some help from my sysadmin to be able to access the server from my desktop.

Edit: Yes the newest version of the ODBC has worked for us, we are running PBI Version: 2.118.828.0 64-bit (June 2023) and ODBC 8.0.33 and it works

Edit2: the past version worked, until it didn't, the only way I could get that to work was installing the 8.0.26 as I suggested at the beginning. This can be done from the "MySql installer - community" installer though, you just need to select the 8.0.26 and that's it.

Edit3: forward to may 2024, a teammate was getting some weird message about a format from the database, we tried the 8.0.26 and it didn't work, 8.0.28 did though. The one that worked for him is the "Windows (x86, 32-bit), MSI Installer" (mysql-connector-net-8.0.28.msi). Take care

Upvotes: 3

WizzVard

Reputation: 1

If you still have this problem, install older version, my newest is 8.3.0, but I installed 8.032. It helped, but I had a new error 'We couldn't authenticate with the credentials provided.'. I solved this by usng not my current credentials, but database credentials that are placed right under Windows credentials on the left. Here you need to place username of ur server connection, for me it was 'root' and your password.

Upvotes: -1