Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
gustavodelgado
Frequent Visitor

Mysql Data Source Credentials

Nice day

I installed the ODBC driver for MySql and was able to connect to the database in Power BI Desktop, but when configuring the data source credentials on the web I get this error:
WhatsApp Image 2020-05-05 at 4.32.37 PM.jpeg

I've already installed several drivers for MySql but I still have the same problem. Someone who can help me?

PSD: You need to have a gateway with MySql, because with Sql Azure you don't ask me for a gateway.

3 REPLIES 3
v-xicai
Community Support
Community Support

Hi  @gustavodelgado  ,

 

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

v-xicai
Community Support
Community Support

Hi @gustavodelgado , 

 

You may connect to the MySQL data using  MySQL database connector, see the detail: Connect Power BI with MySQL Database.

 

Follow the steps, there may be a warning "The connector requires one or more additional components to be installed before it can be used." In this Case - Click Learn More link and it will direct to MySQL connector for the .net page: https://dev.mysql.com/downloads/connector/net/. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit), Install this and restart the computer. 

 

Then in Power BI Service, verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.

 

Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

 

Please make sure the gateway is online, and try to upgrade the gateway to latest version.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

amitchandak
Super User
Super User

@gustavodelgado , Have you installed this driver

https://dev.mysql.com/downloads/connector/net/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.