Can I change only the data source in a developed report? (Azure SQL Data base)

[ted_kim]

Hello! always thankful community members

I want to change the Data Source from Test Azure SQL DB to Live Azure SQL DB. 

The existing Test Azure SQL DB has been authenticated with the database user name and password.

The table structure is the same as Test Azure SQL DB and Live Azure SQL DB.

Can I change only the data source in a developed report?

From Test Azure SQL Database to Live Azure SQL Database

What should I do if it's possible?

[v-yuta-msft · Accepted solution]

Hi ted_kim,

Click Edit Queries-> Data Source Settings-> Change data source like below:

 

Regards,

Jimmy Tao