Forum Discussion

TonyHansson's avatar
TonyHansson
Frequent Visitor
3 years ago
Solved

Power query connect 2 tables to a third table as backend

Hi   Is it possible to use excel as backend for 2 or more connected tables.   If I make a change in one of the frontend tables, it will then change in the backend table? (And therfore change in ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi TonyHansson ,

     

    In Power Query, we can use Merge or Append.

    With above operations, we can combine with two or more tabls to get the 'third table' you mean.

    And if you perform data operations in the original tables, your ‘third table’ will also be updated.

    Append queries

    Merge queries

    Merge Vs. Append Concepts in Power BI (Power Query... - Microsoft Power BI Community

     

     

    Best Regards,

    Stephen Tao

     

    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 TonyHansson ,

 

In Power Query, we can use Merge or Append.

With above operations, we can combine with two or more tabls to get the 'third table' you mean.

And if you perform data operations in the original tables, your ‘third table’ will also be updated.

Append queries

Merge queries

Merge Vs. Append Concepts in Power BI (Power Query... - Microsoft Power BI Community

 

 

Best Regards,

Stephen Tao

 

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