Gateway Connection to MySQL server with On-Premise Personal Mode

[Hariharank04]

Hi All,

I have dataset of mixed datasource, Sharepoint and MySQL.

Sharepoint is connected with Cloud connection which is fine. MySQL is also connected with Cloud connection instead of On premise Personal mode gateway.

Error:

Failed to update data source credentials: An error happened while reading data from the provider: 'One or more errors occurred.

Thanks,

Hariharan

[Hariharank04]

Hi @Anonymous,

Thanks for replying back.

Could you please explain bit more about enterprise gateway?

How to install? Is it free of cost like personal mode gateway? How to connect MySQL connection to enterprise gateway?

Thanks,

Hariharan

[Anonymous · Accepted solution]

Hi @Hariharank04 ,

It is on-premises data gateway(standard mode).

You can view the following document to learn how to install.

Install an on-premises data gateway | Microsoft Learn

On-premises data gateway - Power BI | Microsoft Learn

Add or remove a gateway data source - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

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

[Anonymous]

Hi @Hariharank04 ,

Based on the description, if the MySQL database is not accessible from the cloud, configure MySQL on-premises connections by upgrading to an Enterprise Gateway instead of using a personal on-premises data gateway.

You can also view the following links to learn more information.

Power Query MySQL database connector - Power Query | Microsoft Learn

Solved: Power BI Online connection with MySQL database, ga... - Microsoft Fabric Community

Troubleshoot gateways - Power BI | Microsoft Learn

Troubleshoot Power BI gateway (personal mode) - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

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