Merging Queries Help

[ConnorH]

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 that I need to link to pull data into the model. I am not sure how to though. The new table I need to bring in shares many of the same columns as the old table but the column names are a little different. Also The new table has many new columns I need to keep track of. They both share the same primary key of Project ID. I am looking for advise on merging these tables.

[v-lionel-msft · Accepted solution]

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.

[parry2k]

@ConnorH it is really not easy to follow your question and what you are trying to do. if you post sample data and expected result, it will help to provide the solution

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490