cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lyaneb
Frequent Visitor

MySQL Data Connection with changing passwords

Hello all, 

My company have recently switched to a new database provider, which requires a new password generated on every login to gain access.

I cannot identify how I can connect PowerBI to the MySQL database and then have it allow for a manual refresh whenever needed and auto-refresh through the gateway in powerbi.com, as it requires database credentials to connect in Desktop. I also cannot get it to connect on today's credentials.

 

Has anyone experienced this before, or know of the way around securing the connection, without having to edit the database source credentials on any refresh?

 

Many thanks

Lyane

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi  @lyaneb ,

 

Check the similar thread below:

https://community.powerbi.com/t5/Power-Query/Trying-to-connect-to-MY-SQL-from-Power-BI/td-p/195060

 

Or the blog below:

https://hevodata.com/learn/mysql-to-power-bi/

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

View solution in original post

1 REPLY 1
v-kelly-msft
Community Support
Community Support

Hi  @lyaneb ,

 

Check the similar thread below:

https://community.powerbi.com/t5/Power-Query/Trying-to-connect-to-MY-SQL-from-Power-BI/td-p/195060

 

Or the blog below:

https://hevodata.com/learn/mysql-to-power-bi/

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors