Change server name in gateway connection

[mikesmall]

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 that is a while off).

We are implementing encrypted connections with certificates on our server, but the issue is that the current connection uses the short server name (eg live-sql-db1) and the certificates have the fully qualified domain name (eg live-sql-db1.company.co.uk).  When we connect we will therefore get a mismatch and the connection will fail as there is no equivilent of trust server certificate in the service.

So I would like to change the server name in the gateway connection to be the FQDN.  I have seen a few posts from years ago that say gateway connection authentication can be changed but not the server name.

Can anyone confirm whether this is still the case or whether there is a way to change it with APIs or some other functionality?

I have warned people that we may need to go into hundreds of dataflows and just select a new connection with the FQDN, but this is a big job and I would like to avoid it if at all possible!

Thanks.

[mikesmall]

Thanks both, annoying but I understand.  I think I will explore other options such as using the DBs own certificate until we can move to Fabric copy activities, it will still force encrypted connections in the meantime.

[v-sgandrathi]

Hello @mikesmall,

I want to personally thank @nilendraFabric for your active participation and the valuable solutions you've shared in the community forum. Your contributions truly make a significant impact.

As Nilendra mentioned, the query should be addressed to ensure a proper resolution.

To prevent connection issues, it is advisable to configure a new data source in the gateway using the FQDN.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Regards,
Sahasra.

[nilendraFabric · Accepted solution]

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