Re: MYSQL Connector for Power BI
Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows (https://dev.mysql.com/downloads/file/?id=412152) on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).
After installing the MySQL connector, refer to this blog (https://social.technet.microsoft.com/wiki/contents/articles/32004.power-bi-tips-for-working-with-mysql.aspx) to connect to MySQL in Power BI Desktop.
If the connection still fails in Power BI Desktop, please check that if you are able to connect to the MySQL database in MySQL workbench, and ensure that MySQL workbench is installed in the same machine as Power BI Desktop.
Thanks
Subject
Views
Written By
Posted
4490
May 04, 2023 04:16AM
1266
May 14, 2023 10:56PM
867
February 13, 2024 04:16AM
640
June 27, 2024 06:42PM
Re: MYSQL Connector for Power BI
141
July 21, 2023 01:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.