Forum Discussion
Solved
Combine different database tables
I have two identical databases for separate company I need combine (not join!!) each same_name tables in this two databases How i can do that in M? Now for one database i do something like ...
Hi Analitika ,
The 'otherSteps' lines were just placeholders to represent further transformation steps if you needed to do them, such as 'Changed Types' etc. They are not necessary but show that you must use the last step in each Source segment in the Table.Combine() function.
The data source privacy levels are something that you need to resolve at your end. If these sources are already set up in Power Query, you can try going to Data Source Settings and check that both data sources have the same privacy levels i.e. None, Private, Organisational, or Public.
Pete
already tryied, it provide errors as no linking table exists
ImkeF , what is the best way to comine and have a minimum size?