Is there a way to change your data source without having to update the entire report

[beakon]

I have a Power BI report that is pulling the data from a MySQL database - We have now migrated the database over to a new server - Given the new database and the fields are exactly the same as the old ones, is there a way to update the data source to match the new IP address and database without having to udpate each chart/slicer etc. manually?

[vmakhija · Accepted solution]

@beakon 

Yes, you can do that.

Go to Edit Queries -> Advanced Editor and then you should be able to change the server name, database name, etc.

Once you do this, rest of the things should work fine given that your schema haven't changed.

Regards