Forum Discussion
mikesmall
Advocate I
1 year agoChange server name in gateway connection
We currently have hundreds of dataflows that each extract a table from an on prem SQL server via a gateway (I know, we are moving to Fabric and will use copy data en mass with a single connection but...
- 1 year ago
Hello mikesmall
Currently, it is not possible to change the server name in an existing Power BI gateway connection directly, whether through the Power BI Service UI or APIs. The server name field in the gateway’s data source settings is locked once the connection is created, and any modifications to this field require creating a new data source connection.
The only option is to Create a New Data Source with the FQDN
dpo007
9 months agoRegular Visitor
Is there someplace we can suggest/upvote this feature? Being able to edit the gateway connections after the fact seems like a no-brainer, so that DBs can be changed/migrated without editing every PBI report, etc.