Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Replace table in data model

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 yo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.



pmay's avatar
pmay
Resolver I
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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