Forum Discussion

mikesmall's avatar
mikesmall
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Change 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...
Need Help
  • nilendraFabric's avatar
    nilendraFabric
    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

     

     

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
1 year ago

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.