Combine 2 table in Power BI from different source

Anonymous 

Hello, 

option 1 : if they have the same structure, you can simply append them in power query . 

go to power query , 

select one table,  

go to home -->  append ( you can find this option at the end right ) 

and choose the table that you want to append to the original table. 

if you have different structure , you have 2 options : 

option1 : 

i would suggest to create a star schema where you define the dimensions in new tables, and link those dimensions to these 2 fact tables . 

and in the visuals you read the data from the dimensions, and the measure from the 2 fact tables .

option 2 : 

if they have different structure,

so exmaple . if one table have : company, brand. product, date  as level of detail

and the other table  have : brand, product, date  as level of detail

you can create a table appending the 2 tables on  brand, product and date and use this table when showing visuals at the level of brand, product or date . 

let me know if there anything else i can help you  with .

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit thumbs up button 👍