Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys!
There are two tables with the same name and structure, but in different databases.
How can I join these tables in Power BI Desktop to get united visualization?
Solved! Go to Solution.
Just use an Append query.
Hi @Rumata,
You need to load these two tables from different databases separately into Power BI desktop. Then, you can combine them via "Append" in Power Query or using UNION function to create a calculated table in DAX.
Best regards,
Yuliana Gu
Hi @Rumata,
You need to load these two tables from different databases separately into Power BI desktop. Then, you can combine them via "Append" in Power Query or using UNION function to create a calculated table in DAX.
Best regards,
Yuliana Gu
Thanks so much!
Just use an Append query.
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
71 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |