Myqls data loading problem

[Syndicate_Admin]

Hi, I was connected and working well with my mysql databases, when I had a problem expanding a column in the query. I looked for solutions in the forum and it told me to remove the permissions from the data sources in the settings and reconnect them. After that I could never connect to the same database again, when I am going to load, power bi recognizes that the base exists but it is permanently updated and I can not visualize the tables, before everything appeared instantly. I leave reference image. I only have this problem with MySql, excel does not present any problems.

[v-zhangti]

Hi, @Syndicate_Admin 

Before we can connect to a MySQL database, we need to install MySQL :: Download Connector/NET on our 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 to connect to MySQL in Power BI Desktop.

Power BI Tips for Working with MySQL - TechNet Articles - United States (English) - TechNet Wiki (mi...

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, ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

For reference:

Solved: Connect mysql database problem - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.