cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaya Regular Visitor
Regular Visitor

Import two tables from two DB as UNION

Hello
I want to compare data between two companies,
two companies are from two DB (same server, and the same structure) .
I want to import tables as UNION.
Is it possible and how?
Thanks
(In QLICK VIEW this is possible)
1 ACCEPTED SOLUTION

Accepted Solutions
shaya Regular Visitor
Regular Visitor

Re: Import two tables from two DB as UNION

7 REPLIES 7
sokg Established Member
Established Member

Re: Import two tables from two DB as UNION

Do you know the difference  between merge and append?

Super User
Super User

Re: Import two tables from two DB as UNION

It is also possible in Power BI

Before using Append to create one table with records from both tables create a custom column "Source" with values to mark the records with their source

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
shaya Regular Visitor
Regular Visitor

Re: Import two tables from two DB as UNION

did not know before, I read about MERGE, I did not find APPEND
1. Still if I write a query, I am in the DB environment of one company.
2. I also do not need the MATCHED, because I want all records, the only field that is changed is the company name.


The question is, how can I see the two tables together

And thanks again

shaya Regular Visitor
Regular Visitor

Re: Import two tables from two DB as UNION

Super User
Super User

Re: Import two tables from two DB as UNION

Step 1

Connect to your table from company 1 and make all your transformations

 

Step 2

Connect to your table from company 2 and make all your transformations

 

Step 3

Go to Query Editor

Table Append 0.png

 

 

Step 4a

Mark one of the Queries and in the home tab

Table Append 1.png

 

Step 4b
choose the appropriate Append option
Table Append 1b.png

 

Step 4c

choose the table to append

 

Hope this helps

 

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
shaya Regular Visitor
Regular Visitor

Re: Import two tables from two DB as UNION

Hello Tom
At first, I was looking for the MERGE in SQL, it was my mistake,
after that I found it in the help of POWER BI thanks to you.
Super User
Super User

Re: Import two tables from two DB as UNION

You're welcome!

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)