Adding a row- Getting a Cyclic Reference

[Walt1010]

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)?

[Idrissshatila]

Hello @Walt1010 ,

as @ryan_mayu suggested, create a duplicate of the table and then append it as new and then you can load it as a new table.

do all this in Power Query. 

[Walt1010]

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.

[Anonymous]

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. 

[ryan_mayu]

Did you do this in PQ? You can try Append as New to avoid this.

[danextian]

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.