.pbix. changing of data source globally because of Servermigration

[mgast]

Hi Community

All data sources for all .pbix should be changed to new SQL database. Is there an easy way to do, without opening each .pbix individually? Hope anybody can help.

Thank`s a lot.

Kind regards

[lbendlin · Accepted solution]

That's what you use parameters for?  You can change these on the service.  Of course your new database must be covered by the gateway.

[mgast]

Hi , but if I understand correctly, this only applies to new datasets? The ones that have already been created need to be changed manually? Thank you for response

[lbendlin · Accepted solution]

yes, but it is a one time correction - you should have done this when you originally created the reports/datasets.

[lbendlin · Accepted solution]

That's what you use parameters for?  You can change these on the service.  Of course your new database must be covered by the gateway.