Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help needed with connecting data source, in browser data source valid and in desktop app error

Hi all, i'm trying to connect to an MySQL database. According to powerbi.microsoft I have successfully added the gateway and MySQL data source         I then want to create a dash...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit). I found the latest version is 8.0.17.

    After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop. You need to provide database credentials not windows. 

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit). I found the latest version is 8.0.17.

After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop. You need to provide database credentials not windows.