Merge 2 different datasets having different columns in Power Bi

[nj17]

Hi All,

I have one table which is coming from sql server and another data is coming from excel file.

sql table have 6 columns and excel dataset has 4 columns ,now i want to append excel data to sql table data.

for eg. the columns are

SQL table have A,B,C,D,E,F,G

Excel have B,C,H,I

now i want to append values of column B and C from excel dataset to B and C columns of sql table.

Thanks ,

Nj

[Greg_Deckler]

@nj17 So, to be clear, do you not want H and I columns?

[nj17]

Hi @Greg_Deckler 

yes,so below are columns from excel dataset.I want to append revenue/day to Amount column of sql table

 sql table

so once these revenue/day and Amount appended i can see the total values for a particular store