Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power Query Combine EXISTING tables in tabular model

I would like to combine two existing/already imported tables and form a new table without having to "re-import" them (importing table, duplicate query, merge and then import the combined table). Thus...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

You can use the shared Expression to help merging two existing tables:

Here is a simple sample:

First create a shared expression:

Then you can use the expression to merge/ append:

Then create new table and import

 

Final output:

 

Besides, you may need to create relationship for the new created table manually.

 

Best Regards,

Jianbo Li

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

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi v-jianboli-msft 

 

Thank you for the response. I would like to merge existing tables imported from SQL server source under "Data Sources".

 

It seems that is not possible. You have to create your data sources as expressions in order to merge them.