Forum Discussion
cuongle
Advocate II
Advocate IIChange data source for the whole pbix file
Assume I already have pbix file using "Import Data" approach which is imported around 50 tables from Database 1. Now I want to change Data source of this pbix file to Database 2 which is exactly the ...
The technique I know only works prospectively. It is explained by Chris Webb here, and involves declaring the elements of the data source as a separate M query: http://blog.crossjoin.co.uk/2015/11/09/avoiding-duplication-of-database-connection-information-in-power-bi/.
