Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
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.
You're welcome!
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
Do you know the difference between merge and append?
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
Thank you all
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
Step 4a
Mark one of the Queries and in the home tab
Step 4b
choose the appropriate Append option
Step 4c
choose the table to append
Hope this helps
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |