Solved: Changing SQL data source

MarkWalsh · ‎03-13-2018

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 · ‎03-20-2018

@MarkWalsh,

You may modify code in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎03-20-2018

@MarkWalsh,

You may modify code in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎03-13-2018

@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