March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi
I'm a newbie and have searched arround, but need help on this scenario
I've 4 source
1 DB for location info
3 for device inventory (3 different systems)
Device inventory DB's consistst of columns with information, but som DB have more info then others. and column name can be different.
I want to create visual view where a user can select a location and see all inventory in one table.
Solved! Go to Solution.
Hi @desperado ,
You can consider that append the table Mobile, Tablet and PC in Power Query Editor to make a "summary" query, then create a table visual base on the new table. You can refer the following blog to complete the append operation.
Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX
In addition, it is very important to change the field names representing the same data in these three tables to the same field names before append tables. For example, the name of operating system type field in Mobile table is OS, and the corresponding field names of the other two tables are OSType and DEVOS, which can be renamed to OS just as show in below screenshot...
Best Regards
Hi @desperado ,
You can consider that append the table Mobile, Tablet and PC in Power Query Editor to make a "summary" query, then create a table visual base on the new table. You can refer the following blog to complete the append operation.
Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX
In addition, it is very important to change the field names representing the same data in these three tables to the same field names before append tables. For example, the name of operating system type field in Mobile table is OS, and the corresponding field names of the other two tables are OSType and DEVOS, which can be renamed to OS just as show in below screenshot...
Best Regards
@desperado , Create a common table device type and join with three tables and use device type from that
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |