Forum Discussion
no 'ok' button to accept a relationship
- 2 years ago
In case anyone else has this issue - it ended up being a UI bug which some very helpful microsoft reps helped me work through. The fix involved tabbing to where the 'ok' button should be and hitting enter.
Autodetect fails to recognise any relationships, though when I try to create a very simple PatientId:PatientId relationship, it does correctly detect this is a one:many relationship.
I uninstalled and reinstalled and it hasn't changed: it's just... not there and I am absolutely baffled
So there seems to be some logical issue. Where are your tables coming from?
+
I attached a PBIX of mine, try to remove and create relationships, and check if it works differently.
- Jmo_19822 years agoFrequent Visitor
I deleted the relationship between product ID and product ID and tried to reinstate the relationship.... there is no ok button. What is going on!?
My tables are coming from a direct query to a sql server, but given the same problem is happening with the imported data in your set, this seems to be a Pbi desktop issue... any suggestions for fixing this, given I have already uninstalled and reinstalled?
- Jmo_19822 years agoFrequent Visitor
There is no option to change the import mode to dual - assuming my googling is correct and this is where it is supposed to be - in properties. This is the case for your data set as well as mine