How to switch data source in Desktop

[jarthda]

I have my report .pbix definition currently connected to Azure SQL. I a have the same tables in a SQL instance. What is the best way to replace the connection but keep the report and tables? Is this possible?

Spoiler

[mahimabedi · Accepted solution]

If you only want to change the connection string or point to a new SQL instance, then you can do it under data source settings as well.

[MattAllington]

I'm not sure on the specifics of the connection steps in this case, but in general, you can change any data source as follows

1. Do not delete the current loaded table

2. Load the new table from the new source from scratch. Make sure the final table is identical to the original

3. In the new table query (2 above), go into Advanced Editor and copy all the code

4. Go into advanced editor for the original table (1 above) and paste the code from 2 in place of original code. 

take a backup copy first.