Replace table in data model

[Anonymous]

Hello,

How do I replace table data with the same structure and same title? Exp: Date_1 to Date_2. And after that, I don't need to reset the relationship about this new table with others

Thank you,

Alice.

[SanketBhagwat · Accepted solution]

Hi @Anonymous .
If your Table 1 and Table 2 has similar structure i.e. same number of columns and names then yoc can change data source and replace Table 1 with Table 2.

Click on 'Home', below Transform Data, click on 'data Source Settings', click on your table source and change it with your Table 2 source.

Hope that helps.

Thanks,
Sanket.

If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.

[Anonymous]

I can't reselect the table, just only select the database name.

[SanketBhagwat]

Can't you click on 'Change Source' and change it?

[pmay]

Hi Alice,

To me, this doesn't make sense - I think if you post more information you will get a more meaningful answer.  Where are you trying to replace the data?  In Power Query?  You just want to replace all Date_1 with Date_2?

[Anonymous]

Hi, sorry 🙂 

Now I need to replace a table (involved in multiple relationships) with another one that has the same structure. For example, replace Date_1 with Date_2 without having to reset all the relationships? Thanks 

My database in ODBC