Creating a reference table and then appending it - How can I still use old reports?

[Walt1010]

I performed some analysis using a Base table, and have build my reports from it.

The I had a brainwave and created a reference table ("Ref") from my Base table ("Base"). I made the changes in the Ref table and now want to append it back, becasue i still want to use all the reports I've created.

However I can only append the Base table to the Ref table, not the other way around, presumably because that was how I created the reference table. If I try the other way I get the "cyclic reference" error.

My question: how can I append the 2 queries together so that my reports will run off the 2 appended query?

[Sergii24 · Accepted solution]

Hi @Walt1010, the problem is exactly in "cyclic reference" because table "Ref" is referenced from "Base". To solve the issue, instead of creating reference, you can copy paste the code from "Base" table in "Ref". In such way they will be independent and can be appended.

If you want to avoid connecnting to the data source twice, you can try to use "append as new" in this way evethough, you're referencing the "Base" table you should be able to append them. Then turn off "Base" and "Ref" loading into data model and keep only new append.

I hope it helps! 

[Walt1010]

Hi there, thanks. Justa followup:

"... instead of creating reference, you can copy paste the code from "Base" table in "Ref".". So you mean replicate the whole query to that point? Thats a good idea, thanks!