Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dia612
Helper IV
Helper IV

Changing Data source to entire pbix file

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???

2 ACCEPTED SOLUTIONS
az38
Community Champion
Community Champion

Hi @dia612 

you can change it here

Безымянный.png


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

amitchandak
Super User
Super User

@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

 

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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
Community Champion
Community Champion

Hi @dia612 

you can change it here

Безымянный.png


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.