Changing a Data Source's Database Server Location

[arock-well]

My company is in the process of changing the server location of an on-premises SQL Server database. The new database will have the exact same tables and data structures as the old one. However, I currently have dataflows that are importing data from the old one and I want it to point to the new one without having to redo all my dataflows.

When I go to the Data Source settings it doesn't appear I can change it to the new Server as it is not enabled. Only the data source name appears to be able to be changed.

Is there a way to change the Server location on an existing Data Source? If not, what is the best way to do this?

[arock-well]

I ended up creating new dataflows pointing to the new server and updating the datasets and associated reports to point to them. I did this by @AntrikshSharma  suggestion of downloading the old dataflow JSON files so I didn't have to recreate everything from scratch. But, it would be nice if MS offered an option to repoint existing data sources to another database server when required.

[AntrikshSharma]

@arock-well I guess the only option is to export the JSON file, edit the data source name and then re-import the JSON file in service.

[arock-well]

@AntrikshSharma Just so I understand, which JSON file are you referring to? I know how to download a Dataflow JSON, but is there some why to do this for a gateway Data Source?

It's looking like I'll have to create a new Data Source connection and reconnect all my Data Flows to that, which will be painful.  I'm surprised there isn't a way in the interface to do this.