Microsoft Power BI连接到mysql [英] Microsoft Power BI connect to mysql

问题描述

我的mysql服务器在云上。我安装了连接器以在 Window 7 计算机上连接mysql。然后，我尝试从Power BI连接到MySQL服务器。我提供IP地址和数据库名称，即我的根证书。然后我点击保存。它给了我以下错误。

My mysql server is on the cloud. I install the connector to connect mysql on Window 7 machine. Then I try to connect from Power BI to MySQL server. I give the IP address and database name, my root credential. Then I click on save. It gives me the following error.

DataSource.Error: MySQL: Unable to connect to any of the specified MySQL hosts.
Details:
    Message=Unable to connect to any of the specified MySQL hosts.
    ErrorCode=-2147467259

然后我尝试连接从mysql工作台使用同一台机器上的相同凭据。我可以连接，但不能从Excel Power BI连接。

Then I try to connect from mysql workbench with the same credential from the same machine. I can connect, but I am not connecting from Excel Power BI.

推荐答案

我发现您需要安装特殊的驱动程序才能让PowerBi与MySQL一起使用。该驱动程序的链接实际上在错误消息中（但是您无法单击它或选择文本？）。

I found that you need to install a special driver to get PowerBi to work with MySQL. The link to that driver is actually in the error message (but you can't click on it or select the text?).

mysql-connector-net-6.6.5.msi

mysql-connector-net-6.6.5.msi

我在这里找到了文件。

这篇关于Microsoft Power BI连接到mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！