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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mgaynor
Helper I
Helper I

Change existing Gateway SQL Server Data source

How can an existing SQL Server connection be updated on the Power BI Gateway?  It's greyed out other than the name.  Or does a new one have to be created?  If so, if the new one has the same name, does anything else need to be done or do datasets need to be mapped to the new source (even though the name is the same)?

1 REPLY 1
ibarrau
Super User
Super User

Hi. Server name or database name can't be changed once added to the gateway as a source. You can change credentials for permissions purposes only.

If you have a new instance or database name then it means it's a different source for the gateway and you can add it again. If the name of instance and database is the exact same thing, you just need to change credentials. The test connection is run in the VM or Machine where the gateway is installed, so it's like running the test from there.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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