Changing SQL data source

[MarkWalsh]

I currently have a basic report which contains some visuals. 

This pulls data from my production database.  Is it possible to use the same PBIX file but change the source connection? I have a development database and a quality database and ideally I'd like to be able to just repoint my PBIX report to these other databases.

[v-chuncz-msft · Accepted solution]

@MarkWalsh,

You may modify code in The Advanced Editor.

[Anonymous]

@MarkWalsh,

Assuming that your development and quality databases have the same schema and table names like you have in your production database, you can go Options and Settings --> Data Source Settings and then select Change Source to point it to your prefer database