Forum Discussion
Changing a Data Source's Database Server Location
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 cur...
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.