Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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:
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.
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
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:
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.
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
@Paulyeo11 , Not clear,
did you append it on power query or have you created source column by using DAX?
Regards,
Manikumar
Proud to be a Super User!
Hi Mani
I create column at DAX.
I append at PQ. Append can be preform at DAX ?
Paul
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |