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 ,

 

This article may help you: Quirks of Visual Studio Query Editor working with Analysis Services – business intelligist

 

If you were to open the Query Editor screen for another table in the Tables folder, you will not see any other tables, but you will see the new (shared) Expression. With this, you can merge, append, or do whatever else you’d like.

 

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 

     

    So it seems that it is not possible to say merge two existing tables imported from the source eg a table/view from SQL database?

     

    Or are you saying that you should copy ALL your SQL queries into the "native query" part of Power Query?

     

     

     

    It seems that this may not be effecient if the majority of the model's source is from SQL. Also would all relationships be created automatically if you generate all tables in this manner?