Forum Discussion

ConnorH's avatar
ConnorH
Microsoft Employee
6 years ago
Solved

Merging Queries Help

So I have a sloppy data model already created for a large report I have created and I dont really want to move around columns due to custom columns I have created already. But I have another source t...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi ConnorH ,

     

    Do you want to introduce new data sources into the already created data model?
    First delete the table relationships in the model, then merge the tables in "Edit Query", and then re-establish the table relationship.

    (Transform data -> Home -> Merge Queries)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi ConnorH ,

 

Do you want to introduce new data sources into the already created data model?
First delete the table relationships in the model, then merge the tables in "Edit Query", and then re-establish the table relationship.

(Transform data -> Home -> Merge Queries)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.