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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Starstorm
Frequent Visitor

Merging Tables From Two Different Data Sources With DIFFERENT Schemas

Dear All,

 

Need some help with merge two different data sources as seen below into one singular table for analysis purpose.

 

Schema.png

 

In short, the differences between 1 and 2 are such that they have different schemas, and for Source 2 in particular, the amounts are split into a more granular by cost types i.e. Cost 1 to Cost 6.

 

For instance, Data Source 1 10004ABCDE has a total amount of $4,000.00; and Data Source 2's amounts will also add up to $4,000.00.

 

As I need to consolidate both data sources so that I can pull the fields/measures from just a singular database. How do I go about having Data Source (1+2) as seen on the far right? Also, there is another problem of duplication because the third table on the right will result in a total of $8,000.00 - is there a way to remove the double count?

 

Thank you.

2 REPLIES 2
amitchandak
Super User
Super User

Thank you, but is there a way just solely to be performed without using a power query?

 

How does merge and append resolve the duplication?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.