Microsoft Fabric - Edit the Connection Properties

[Sathish133]

Hi Team,

I am using the Microsoft Fabric and created the on Premise Gateway and created the ODBC connections which are used in the pipelines.

Now my On Premise Gateway and ODBC DSN has changed. So I want to Edit my existing connection to repoint my ODBC DSN & On Premise Gateway. But in connection level there is no option to edit these properties. Its allowing only to edit the Username & Password.

Can you please confirm, any other way to change the existing connection or only option is create a new connection and all the pipeline level need to point my new connection.

Regards,

Sathish Kumar

[v-karpurapud]

Hi @Sathish133 

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.

[Sathish133 · Accepted solution]

Yes, Got the confirmation. It is Fabric Limitation.

[v-karpurapud]

Hi @Sathish133 

Hope you are doing well!

As the limitation has been identified and acknowledged, we will now proceed to close this thread. If you have any further questions or need additional assistance, please feel free to open a new thread.

Thank you for being part of Fabric Community Forum.

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.

[v-karpurapud]

Hi @Sathish133 

Thank you for the confirmation. We hope your issue gets resolved soon. In the meantime, kindly consider Accept solution so that it can benefit others in the community facing similar challenges.

Thank You.

[v-karpurapud]

Hi @Sathish133 

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.

[v-karpurapud]

Hi @Sathish133 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also , thank you @ABD128 for your quick response.

In Microsoft Fabric, the ability to edit connection properties for an existing on-premises data gateway connection is limited, particularly when attempting to update the On-Premises Data Gateway or ODBC DSN. Currently, the "Manage connections and gateways" interface allows modifications only to authentication credentials, such as username and password, and does not provide options to directly alter the gateway or DSN settings.

To address this, the recommended approach is to create a new connection with the updated gateway and ODBC DSN configurations. Once the new connection is established, you will need to reconfigure your pipelines to reference this new connection to ensure seamless integration with the updated settings.

For detailed guidance on setting up and managing connections, please refer to the Microsoft Learn documentation onData source management and How to access on-premises data sources in Data Factory .

Manage an on-premises data gateway | Microsoft Learn

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.

Thank You!

[ABD128]

Hi @Sathish133 

In Microsoft Fabric, once a connection is created using an ODBC DSN and an On-Premises Gateway, these properties cannot be modified. The only editable fields are the username and password. Therefore, if your DSN or gateway has changed, the recommended approach is to create a new connection with the updated settings and update all associated pipelines or dataflows to reference this new connection. This ensures stability and alignment with current platform limitations.

If my response resolves your query, kindly Accept it.

Thanks.