Very odd circular reference message

[masplin]

I renclty started working with desktop and imported an extensive excel model.  I just relaised a relationship was missing so added it inot my excle modle and al lworked fine. I then went and added it to the desktop model and got this strange error message

Firstly why woudl the relationship be ok in my excel and not in desktop. Are there differnet rules?

Secondly the reference is some weird code not a column name which is what i woudl expect?

Thanks for any clues as sabotaged my move to desktop on day one. 

Mike

[Anonymous]

From my own experience, this can come up depending on how some of your calculated columns and measures have been written.  These create table references from what i've seen and i've run into a similar message in the past.

[masplin · Accepted solution]

Seems odd it works in powerpivot, but not in Desktop

Turns out the solution was to turn off the other 2 relationships on the table, addin the new relationship and then turn the old relatioships back on. Voila!!!!

I think that counts as a bug.

Mike