Forum Discussion
Advocate IIChange data source for the whole pbix file
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/.
Skilled SharerThe 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/.
asocorro Hello,
I have pbix file sent by a colleague and I want to use the same pbix file including my colleagues template for my own data.How do I do this?
Kind regards
M
- asocorro
Hi, you would have to do a query-by-query analysis to see where the data for each table in the report is coming from and then replace those sources with yours. In Power BI, a report can get data from many sources at once (e.g., databases, Excel files, etc.).
Thank you. I guess its how to change the data source so it reads my own data