Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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
Country | Product | Sales |
UK | Bread | 10 |
UK | Milk | 20 |
USA | Bread | 50 |
USA | Milk | 200 |
France | Bread | 30 |
France | Milk | 10 |
from this table I generate a Total Sales table and use this to create a sort column
CountryTotal SalesSort
USA | 250 | 1 |
France | 40 | 2 |
UK | 30 | 3 |
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?
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.