Forum Discussion
Connector/NET 9.4.0
Hello, I am trying to connect to a MariaDB data source using the MySQL connector. My Power BI desktop indicated I need to install the connector. I installed the MySQL Connector/NET 9.4.0 but Power BI did not identify it as installed. Trying to figure out what I am doing wrong.
Hi TomSinAA,
You’re seeing the “install the MySQL connector” prompt because Power BI Desktop can’t find a registered ADO.NET provider called “MySQL Data Provider.” That happens when the wrong architecture is installed, the provider wasn’t registered in .NET, or multiple/conflicting entries exist. MariaDB is wire-compatible with MySQL, so you can connect either via the MySQL provider or use the MariaDB connector route.
Troubleshooting steps:
- Install the correct ADO.NET provider (x64) and verify it’s registered
Uninstall all MySQL Connector/NET versions. Install the Oracle MySQL Connector/NET (x64). If 9.4.0 isn’t detected on your machine, try 8.2.0 (MSI) which included fixes for Excel/Power BI detection. Download: MySQL Connector/NET. Why 8.2.0 is a safe bet: Oracle noted a fix for apps like Excel and Power BI after 8.0.33; 8.2.0 includes that fix. See release notes: MySQL Connector/NET release notes.
Close Power BI Desktop, then confirm registration by running this in PowerShell:[System.Data.Common.DbProviderFactories]::GetFactoryClasses() | Out-GridView
You should see MySQL Data Provider (MySql.Data.MySqlClient). If you don’t, Power BI will keep prompting. Microsoft Learn: MySQL connector prerequisites - If it still isn’t detected, clean duplicate provider entries
Open (as Administrator) the machine.config for .NET Framework (back it up first):
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
If needed, also check Framework\v4.0.30319\Config\machine.config.
In the <DbProviderFactories> section, remove duplicate “MySQL Data Provider” lines so only one remains for the version you installed. Reinstall Connector/NET (x64) and restart Power BI. Community members have reported this resolves the persistent prompt. Community thread with machine.config fix - Alternative for MariaDB: use the MariaDB connector path
In Get Data, pick MariaDB (DirectQuery supported). If prompted, install MariaDB ODBC 3.1+; the MariaDB Direct Query adapter uses the ODBC driver. Docs: MariaDB Direct Query Adapter for Power BI - Planning to refresh in the Service?
Install the same connector on the on-premises data gateway machine (personal mode isn’t supported for MySQL). MySQL connector prerequisites (gateway note)
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
- Install the correct ADO.NET provider (x64) and verify it’s registered
5 Replies
Hi TomSinAA,
You’re seeing the “install the MySQL connector” prompt because Power BI Desktop can’t find a registered ADO.NET provider called “MySQL Data Provider.” That happens when the wrong architecture is installed, the provider wasn’t registered in .NET, or multiple/conflicting entries exist. MariaDB is wire-compatible with MySQL, so you can connect either via the MySQL provider or use the MariaDB connector route.
Troubleshooting steps:
- Install the correct ADO.NET provider (x64) and verify it’s registered
Uninstall all MySQL Connector/NET versions. Install the Oracle MySQL Connector/NET (x64). If 9.4.0 isn’t detected on your machine, try 8.2.0 (MSI) which included fixes for Excel/Power BI detection. Download: MySQL Connector/NET. Why 8.2.0 is a safe bet: Oracle noted a fix for apps like Excel and Power BI after 8.0.33; 8.2.0 includes that fix. See release notes: MySQL Connector/NET release notes.
Close Power BI Desktop, then confirm registration by running this in PowerShell:[System.Data.Common.DbProviderFactories]::GetFactoryClasses() | Out-GridView
You should see MySQL Data Provider (MySql.Data.MySqlClient). If you don’t, Power BI will keep prompting. Microsoft Learn: MySQL connector prerequisites - If it still isn’t detected, clean duplicate provider entries
Open (as Administrator) the machine.config for .NET Framework (back it up first):
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
If needed, also check Framework\v4.0.30319\Config\machine.config.
In the <DbProviderFactories> section, remove duplicate “MySQL Data Provider” lines so only one remains for the version you installed. Reinstall Connector/NET (x64) and restart Power BI. Community members have reported this resolves the persistent prompt. Community thread with machine.config fix - Alternative for MariaDB: use the MariaDB connector path
In Get Data, pick MariaDB (DirectQuery supported). If prompted, install MariaDB ODBC 3.1+; the MariaDB Direct Query adapter uses the ODBC driver. Docs: MariaDB Direct Query Adapter for Power BI - Planning to refresh in the Service?
Install the same connector on the on-premises data gateway machine (personal mode isn’t supported for MySQL). MySQL connector prerequisites (gateway note)
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
- Install the correct ADO.NET provider (x64) and verify it’s registered
Hi TomSinAA ,
Thank you for reaching out to the Microsoft Community Forum.
Hi tayloramy , Thank you for your prompt response.
Hi TomSinAA , In addition to tayloramy response, i have added some more points.
As you mentioned in your query, Power BI isn't recognizing MySQL Connector/NET 9.4.0. Please try below things to fix the issue.
1. Please Uninstall Connector/NET 9.4.0. And download and install MySQL Connector/NET 8.0.28 (64-bit) from the MySQL Archives. And then restart your system. Open Power BI and try connecting again.
2. If you don't want to downgrade, Use ODBC Instead of Native Connector, Install MySQL ODBC 8.0 Unicode Driver (64-bit). In Power BI, go to Get Data --> ODBC, and select your DSN. It works with both MySQL and MariaDB.
3. If you are using the Microsoft Store version of Power BI Desktop, it may not properly load external connectors.
Try to download and install the Power BI version MSI installer from powerbi.microsoft.comNote: If you have tried multiple versions, consider cleaning up registry entries and cached data before reinstalling.
Please refer below links.
Solved: Connect MaridDB to Power Bi - Microsoft Fabric Community
Solved: MySQL: This connector requires one or more additio... - Microsoft Fabric Community
Solved: MySQL Connector Not Working - Microsoft Fabric Community
Solved: Unable to Connect to MySQL Database in Power BI – ... - Microsoft Fabric Community
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi TomSinAA ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi @TomSinAA ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
