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.
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
Solved! Go to 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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |