Hello ,
I need help. How to combine 2 table in Power BI from different source. The first one from snowflake data source. And the other one from excel. And both of them have different measure.
From the first one, I want take 1991 until 2021. And the other one for 2022-2023
Any workaround to do this ?
Thank you
1 ACCEPTED SOLUTION
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 👍
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 👍
Hello @Daniel29195 ,
After try some of you option. I manage to get it done.
I use this one :
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 .
Thank you !
