Forum Discussion
Append reference table
Hi Everybody!
I have an issue while trying to append a table and a reference of itself in power bi. It seems that it's not possible.
I've got:
Table 1
Table 1 (reference) with some replaced values
I would like to append the Table 1 (reference) to the Table 1 and it seems that I can't, because I have no option to choose "Table 1 (reference) the table to append to Table 1.
Someone is able to help???!!
Many thanks!!!!!!
3 Replies
- Nathaniel_CCommunity Champion
Hi Anonymous
I have a reference table created in Power Query, when I click on Append, I have both tables showing. Which table I choose will be appended to the table that is already in the window. It does seem to work. Click on the drop down arrow.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πare nice too.
Nathaniel- AnonymousNot applicable
Hi Nathaniel,
Thanks for your answer! The problem is that the direction of the reference is the opposite. Is like a cyclic reference...
- Nathaniel_CCommunity Champion
Hi Anonymous
Not sure what you mean by the direction of the reference?