Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all
I have just come across what I think is a bug in the relationships view of PBI Desktop.
When I drag the primary key from one table to the key field of another table to establish a relationship (which has always worked) I get the standard popup for 'New Relationship'. However on both tables it says 'A preview of this table isn't available' which is strange as the tables are pretty simple. there is no message as to why
When i set the settings for the relationship, i tick the 'Make this relationship active' button and it doesn't provide any feedback as to it being unsuccessful, then I press 'Save'. I get the 'Working on it' and spinning wheel, but nothing happens, the relationship does not establish.
What i realised is there is in fact ambiguous relationships as a result, so that relationship I was trying to make can't work, once I removed those other relationships, I was able to successfully establish the intended new relationship. However, troubleshooting this took me an extra bit of time to work out, where as previously PBI told me that immediately.
In short - it seems there is no live relationship checking prior to saving the relationship.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.