Multiple source - one visual table

[desperado]

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.

[Anonymous · Accepted 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

[amitchandak]

@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