Forum Discussion

Walt1010's avatar
Walt1010
Helper V
1 year ago

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 Po...
Need Help
Tips and Tricks
Walt1010's avatar
Walt1010
Helper V
1 year ago

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's avatar
Anonymous
Not applicable
1 year ago

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.