topic Re: Access issues for MySQL database when Taking over data flow in Dataflow

Access issues for MySQL database when Taking over data flow

k_foxy — Thu, 13 Mar 2025 10:17:37 GMT

We have issue with connection to MySQL database.
When myself or my colleague creates data flow in pipeline using existng MySQL connection it works fine. When we use functionality Take Over data flow, the connection stopps working.

Error message.
We could not evaluate this query due to invalid or missing credentials.

This is happening for both of us. Even after Take Over I add connection credentials it does not work. Looks like mechanism Take over breaks connection. Is there solution to this?

Re: Access issues for MySQL database when Taking over data flow

nilendraFabric — Thu, 13 Mar 2025 13:30:26 GMT

Hello k_foxy

Sometimes Take Over process doesn’t properly maintain or transfer the connection configuration between owners

If you can access the advanced settings of your data source within the gateway configuration

Try explicitly set the “Connection Encryption setting for this data source” to “Encrypted”

it helped many users facing the similar issues

Re: Access issues for MySQL database when Taking over data flow

k_foxy — Fri, 14 Mar 2025 12:26:04 GMT

When I use option Encrypted it will not connect to the source. The source is not allowing SSL connections.

Re: Access issues for MySQL database when Taking over data flow

k_foxy — Tue, 18 Mar 2025 07:19:21 GMT

What I noticed in Vnet gataway logs is that credentials are missing, even when I add them it will not connect me, looks like "Take Over" removes credentials to MySQL. How to overcome this ?

Re: Access issues for MySQL database when Taking over data flow

Anonymous — Fri, 09 May 2025 11:01:33 GMT

Hi k_foxy
Thank you for reaching out microsoft fabric community forum.

Thanks for the details and the log — this is a known issue where the “Take Over” action can break the connection by removing or not transferring the saved credentials, especially with VNet Gateways and non-SSL MySQL sources.

Since your server doesn’t support SSL, setting the encryption to "Encrypted" won’t work. Instead, after taking over the dataflow, try deleting and recreating the MySQL connection, making sure to set the encryption to “Not Encrypted.” Then rebind the dataflow to this new connection.

Also, check that the VNet Gateway allows non-SSL connections, as it may default to requiring encryption even if the connection says otherwise.

This usually resolves the issue, as the problem stems from credentials being tied to the original owner.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.

Re: Access issues for MySQL database when Taking over data flow

Anonymous — Wed, 14 May 2025 11:51:53 GMT

Hi k_foxy

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Access issues for MySQL database when Taking over data flow

Anonymous — Tue, 03 Jun 2025 10:45:16 GMT

Hi k_foxy
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Re: Access issues for MySQL database when Taking over data flow

k_foxy — Tue, 03 Jun 2025 16:43:07 GMT

Hi I think I have resolved the issue