HelloI 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)

Import two tables from two DB as UNION | Microsoft Fabric Community

sokg
Solution Supplier
9 years ago
Do you know the difference between merge and append?
- Anonymous
  Not applicable
  9 years ago
  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
  - Anonymous
    Not applicable
    9 years ago
    Thank you all
TomMartens
Super User
9 years ago
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

Anonymous

Not applicable

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.