Forum Discussion
Combining Tables from different data sources in Tabular Model
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})
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})
How would you do this where the data source is different databases/files?
The above is not dependent upon whether data source is same or different.
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.