Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
desperado
Regular Visitor

Multiple source - one visual table

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.

desperado_0-1623926624595.png

 

desperado_1-1623926633778.png

 

 

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

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...

yingyinr_0-1624355527720.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

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...

yingyinr_0-1624355527720.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.