cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Impactful Individual
Impactful Individual

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 differeniate the company AR table. May i know any work around ?

Paulyeo11_0-1605933282935.png

 

1 ACCEPTED SOLUTION

Hi @Paulyeo11 ,

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:

Q1.pngQ2.png

Create a column in table1:

column.png

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

append.pngnew.png

 

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.

View solution in original post

7 REPLIES 7
Super User I
Super User I

@Paulyeo11 , 

Still unclear, soffy for that. 

Calculated column v=cannot be viewed on Power uery Editor. Did you append or concatenated the sources?

I Columns you can Append by using UNION function. 

 

Regards,

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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

Hi @Paulyeo11 ,

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:

Q1.pngQ2.png

Create a column in table1:

column.png

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

append.pngnew.png

 

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.

View solution in original post

Impactful Individual
Impactful Individual

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

Super User I
Super User I

@Paulyeo11 , Not clear, 

 

did you append it on power query or have you created source column by using DAX? 

 

Regards, 

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Hi Mani

I create column at DAX.

I append at PQ. Append can be preform at DAX ?

Paul

Super User IV
Super User IV

@Paulyeo11 , Nor very clear. But column created in DAX will not get added in Power Query append.

Power Query do not see any column created in DAX



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors