Since the latest upgrades to Desktop i think i have found an issue with the Merge Query. It no longer allows you to merge two tables if the second table is created using reference to the first.
here is a dummy example....
I have some Sales data
from this table I generate a Total Sales table and use this to create a sort column
I disable the load, and then try to merge the Total Sales and Sort back on to the main table, but it will not allow me to select the second table and it appears in the Query list with a warning sign beside it. This used to work, and we have used it in previous reports, the previous reports still work, btu we can not make changes to the merges in these files.
I'm assuming a mechanism has been created to try and stop Circular references in the model. can this please just be changed to a warning and the previous functionality fixed?