Microsoft Fabric - Edit the Connection Properties

Hi Anonymous 

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.

Hi Anonymous 

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!

Hi Anonymous 

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.

Hi Anonymous 

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.

Did you find a solution for this?