Append reference table

[Anonymous]

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!!!!!!

[Nathaniel_C]

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

[Anonymous]

Hi Nathaniel,

Thanks for your answer! The problem is that the direction of the reference is the opposite. Is like a cyclic reference... 

[Nathaniel_C]

Hi @Anonymous 
Not sure what you mean by the direction of the reference?