cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swaroopkumarmg
Helper II
Helper II

Retain model relationship with new dataset

Hello there,

 

I have a power bi file that takes in data from 4 excel files - Calendar, Product, Location, Sales, and Stocks along with some visuals. 

these tables are connected with Relationships. 

the Situation is I get a different dataset with the same excel file names, with this I would want to change the dataset but retails the relationships between them. how can I do that? 

 

whenever I remove the existing table and replace it with the new one, the relations are lost and I have to connect them back. 

EX: I remove the existing Products table and then upload a new Products table, the relationship is lost.

1 ACCEPTED SOLUTION
PaulDBrown
Super User
Super User

If the column names and table structures are the same, change the data source file in Power Query





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
PaulDBrown
Super User
Super User

If the column names and table structures are the same, change the data source file in Power Query





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors