Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Merge 2 different datasets having different columns in Power Bi

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

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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