Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Combining Tables from different data sources in Tabular Model

I have two different SQL server databases/data sources in my Tabular Model I would like to combine two tables from two different sources (one table from each source) with the exact same design in ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    2 years ago

    In PQ, in a new Query, you can put following formula where you would need to replace Table1 and Table2 with respective query names

    =Table.Combine({Table1, Table2})

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi

 

Thank you for helping me.

 

Could you share some M code with me?
Where do you go to create the new query?

I only know how to combine tables from the same source eg Import New Tables from a specific source and then appending multiple queries when I import multiple from the same source.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

First we can import two tables via Get Data.

Here one table is derived from SQL Server and the other from PostgreSQL.

Then please try append queries as new:

Please ensure that privacy levels are consistent.

We can get the combined table:

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum