Forum Discussion
Adding a row- Getting a Cyclic Reference
I need to split a row of my main table/file into 2, so I did a reference copy, in the 2nd file I filtered down to the specific row, and then tried to append it to the original file. Unfortaunately Power BI saw straight through me, and threw up a cyclic reference error:(
How can I get around this without creating a new file to append to, (because I have so many visuals based off the original one)?
5 Replies
Hi Walt1010
That is expected as your second table references the first table but you still want to append the result of the second table which still references the first table. Instead, Reference your first table twice, disable it's loading, and then append the filtered table to the other referencing table.
Did you do this in PQ? You can try Append as New to avoid this.
Thanks. Ive just tried that, and I'm getting weird things happening. The data in the newly created append table is sometimes not appearing in the visual, even after a refresh. I suspect that creating the reference copy and appending it back has confused the report somehow.
Hi Walt1010 ,
Can you check if the append table data is correct in the power query? Then please make sure that your original, referenced and append tables are checked for load and refresh and click “Apply and Close”. Then check again in the data pane of PBI Desktop that the data in the append table is correct.
What visual objects are your data not showing up on? For visual objects, such as tables, duplicate rows are automatically ignored. This is by design.My test:
Table:
Table 2: Referencing the table and filtering
Append:(Append as new)
Check three tables:
Check in desktop:
Table visual:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
