Forum Discussion

shahid_tanmoy's avatar
shahid_tanmoy
Icon for Helper I rankHelper I
3 years ago

How do I append two sources in DAX code instead of the append button?

Hi All,  I have two JSON sources.  Normally I would have to create two seperate JSON sources and append the 2nd to the first.  Can someone write me out the code to do it all in one?  Thanks!    ...
Need Help
shahid_tanmoy's avatar
shahid_tanmoy
Icon for Helper I rankHelper I
3 years ago

so here is the thing, it works when the columns are the same,  but not when the 2nd source has different columns than the first, it gives me only the first table in the combine table. 

 

For example: 

if source 1 has account, impressions, conversionamount

if source 2 has account, impressions,revenueamount

 

it only gives me source 1 values, but if the column names are the same that error doesnt happen

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi shahid_tanmoy 

For the last column that has a different name, you want to combine them into the same column after appending or into two columns with their own names? If you want to combine them into the same column, you need to rename either of them because the Table.Combine() functions works based on the column names. If you want to have them in different columns, I think that is currently what Table.Combine() does. I haven't met the scenario that it would lose the second table that has different column names. 

Append queries - Power Query | Microsoft Learn

Table.Combine - PowerQuery M | Microsoft Learn

  • shahid_tanmoy's avatar
    shahid_tanmoy
    Icon for Helper I rankHelper I
    3 years ago

    I want to the same column and I want to use the name of the first source as the column header. 

    so possibly a code before the combine.tables line that changes the name of certain columns in the 2nd source if you can write out a code like that for me. 

    • v-jingzhang's avatar
      v-jingzhang
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi shahid_tanmoy 

      Please try this 

      RenameColumns = Table.RenameColumns(#"Converted to Table2", {{"revenueamount", "conversionamount"}}),
CombineTables = Table.Combine({#"Converted to Table", RenameColumns}),
      • shahid_tanmoy's avatar
        shahid_tanmoy
        Icon for Helper I rankHelper I
        3 years ago

        Hi, this didnt work, do you have to expand first or something? 

        It says column not found but I know column exsists in the source 2, it gives me the error in the rename columns part. 

        Can you rewrite this? 

         

         

        let
        Source1 = Json.Document(Web.Contents("https:/--Source1urlhere--account_name&_renderer=powerbi")),
        Source2 = Json.Document(Web.Contents("https:/---Source2urlhere--account_name&_renderer=powerbi")),


        #"Converted to Table1" = Table.FromRecords({Source1}),
        #"Converted to Table2" = Table.FromRecords({Source2}),

        #"RenameColumns" = Table.RenameColumns(#"Converted to Table2", {{"account_name", "account_name"}}),   GIVES ME AN ERROR HERE 


        #"CombineTables" = Table.Combine({#"Converted to Table1", #"RenameColumns"})


        in
        #"CombineTables"