Change data source for the whole pbix file

[cuongle]

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 same database schema.

I see one way to open Adance Editor each table to change the Source, this way works but I have to manually change Source 50 times for 50 tables. Is there any other approaches that I am able to change Source in one time for every tables.

[odegarun]

One way I found:

http://community.powerbi.com/t5/Desktop/Solution-Changing-datasource-from-Import-to-Direct-Query-gt/...

[asocorro · Accepted solution]

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-po...

[MichaelAkpos]

@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.).

[MichaelAkpos]

Thank you. I guess its how to change the data source so it reads my own data

[cuongle]

@asocorro This way does not work when we publish to PowerBI service and do data refreash over enterprise gateway.

[asocorro]

What kind of error are you getting?

[cuongle]

Awesome! Thanks a lot