Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
6 years ago
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

 

let
Source = Sybase.Database(SelectServer, SelectDatabase),
DBA_view_DidknObj = Source{[Schema="DBA",Item="view_DidknObj"]}[Data]
in
DBA_view_DidknObj

 

Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    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