Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Append 2 AR Table , Those column created missing

Hi All I have a AR Table , after import to PBI , i add one more column = SOURCE , When i append with another AR Table , i notice that both SOURCE field missing. Since the SOURCE field to differeniat...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    Not clear, did this issue be solved? 

    I have done a simple test but could not reproduce it in my environment.

    I have got two tables from SP folder:

    Create a column in table1:

    When append these two tables in power query, close and apply it, the column wil be updated.

     

    If it is still not solved, perhaps you can consider sharing more details about this issue for further discussion.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mani 

I at first I concatenated each SOURCE by using SHAREPOINT folder load. 
And finally I append both table into 1

Since DAX field after Append will be missing , I will append then Do DAX

 

I am very scare to use UNION

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

Not clear, did this issue be solved? 

I have done a simple test but could not reproduce it in my environment.

I have got two tables from SP folder:

Create a column in table1:

When append these two tables in power query, close and apply it, the column wil be updated.

 

If it is still not solved, perhaps you can consider sharing more details about this issue for further discussion.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Ying

    thabk you very much for your effort . By the way I append the 2 table and Amit help me record my payment term usingng some simple script and it work fine. 
    paul