Forum Discussion
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 you,
Alice.
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.
5 Replies
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?
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.
