Connect to MySQL Error

[JunFeng]

the mysql database can be connect in the desktop but can't connect in the power bi service online with the same information(server, username and password), i'm not sure where's the problem. Can you give me some guide for this problem? Thanku!!

[Akash_Varuna · Accepted solution]

Hi @JunFeng , It might be related to the gateway configration could you check for that

[v-aatheeque · Accepted solution]

Hi @JunFeng ,
Thanks for the question and using Fabric community platform.

@Akash_Varuna Thanks for prompt response. In addition to that :

• Power BI Service requires an on-premises data gateway to connect to MySQL databases that are not cloud-based. Ensure that you have the gateway installed and configured correctly.
• Make sure you are using the standard mode of the on-premises data gateway, as the personal mode does not support MySQL connections.
• Ensure the gateway is correctly installed and configured, and that it has connectivity to your MySQL server
• Ensure you're using the same credentials in the Power BI Service as you are in Power BI Desktop, Inaccurate credentials will cause connection failure.
• Verify that your MySQL server is accessible from the machine where the gateway is installed. The gateway needs to be able to "see" the MySQL server.
• check that you are using the correct authentication type (Basic or Database) in Power BI Service when entering your credentials.In Power BI Service, navigate to the "Manage Gateways" section and ensure your gateway is online and configured correctly.

Additionally you can refer this doc : How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!
 

[v-aatheeque · Accepted solution]

Hi @JunFeng ,
Thanks for the question and using Fabric community platform.

@Akash_Varuna Thanks for prompt response. In addition to that :

• Power BI Service requires an on-premises data gateway to connect to MySQL databases that are not cloud-based. Ensure that you have the gateway installed and configured correctly.
• Make sure you are using the standard mode of the on-premises data gateway, as the personal mode does not support MySQL connections.
• Ensure the gateway is correctly installed and configured, and that it has connectivity to your MySQL server
• Ensure you're using the same credentials in the Power BI Service as you are in Power BI Desktop, Inaccurate credentials will cause connection failure.
• Verify that your MySQL server is accessible from the machine where the gateway is installed. The gateway needs to be able to "see" the MySQL server.
• check that you are using the correct authentication type (Basic or Database) in Power BI Service when entering your credentials.In Power BI Service, navigate to the "Manage Gateways" section and ensure your gateway is online and configured correctly.

Additionally you can refer this doc : How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!
 

[v-aatheeque · Accepted solution]

Hi @JunFeng ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know

Thank you.

[v-aatheeque]

Hi @JunFeng ,

We wanted to follow up regarding your last inquiry, as we haven't received a response yet. Have you found a resolution? If our previous answer was helpful, please click "Accept Answer" and select "Yes." If you have any further questions, feel free to reach out!

[v-aatheeque]

Hi @JunFeng ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[Akash_Varuna · Accepted solution]

Hi @JunFeng , It might be related to the gateway configration could you check for that

[JunFeng]

Oh, let me have a try to use a gateway to connect to my database. Thanks！