Changing Data source to entire pbix file

[dia612]

Hello,

I have 5-6 reports in one .pbix file where data belongs to particular country.

Now I want another .pbix file with same reports but the data belongs to another country.

I can get new table that belongs to new country > go to advanced editor>copy the code

then go to old table that contains previous country data > goto advanced editor> paste the new country code previously copied there...

But I need to do that for each and every table(for me there are like more than  20 tables)

Is there a way where we  can change the data source for the entire .pbix file to change at a tym???

[az38 · Accepted solution]

Hi @dia612 

you can change it here

[amitchandak · Accepted solution]

@dia612 , You can change source connection using edit data source setting under Data Transformations

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources

[az38 · Accepted solution]

Hi @dia612 

you can change it here