Forum Discussion

sbmeder's avatar
sbmeder
Icon for Helper I rankHelper I
9 years ago
Solved

Append Data Merge Data

When we archive data in our ERP system it moves the transaction data from the current data ARTRAN to an archive table ARYTRN. My DAX abilities are limited, but I would think I would need to merge? t...
Need Help
  • sbmeder's avatar
    sbmeder
    9 years ago

    Thank you for your response. I did an import of the tables and it appended very easily.

     

    Regards,

     

    Scott B. Meder

cgaine's avatar
cgaine
Frequent Visitor
9 years ago

You can use the DAX method UNION to merge the 2 tables within PowerBI as long as the 2 tables have the same columns. Under the modeling tab select New Table, and enter the expression below.

 

New Table = union(ARYTRN , ARTRAN)

 

Hope this helps.

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    In the query editor you can append without worrying about table structure and the resulting table will have better compression.

  • sbmeder's avatar
    sbmeder
    Icon for Helper I rankHelper I
    9 years ago

    Will this method work with direct query?

     

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      Hi sbmeder,

       

      Based on my test, Append Queries and Append Queries as New are not supported in DirectQuery mode. Assume you connect to SQL Server database, in Get Data wizard, you can write the T-SQL to merge data.

       

       

       

      Best Regards,
      Qiuyun Yu

    • sbmeder's avatar
      sbmeder
      Icon for Helper I rankHelper I
      9 years ago

      Thank you for your response. I did an import of the tables and it appended very easily.

       

      Regards,

       

      Scott B. Meder