This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hi all,
I am experiencing a problem creating new relationships in Power BI desktop when using direct query to a sql server.
I am updating a dashboard I created a few months ago, and when trying to add new data sources and form simple relationships, there is no 'ok' button to accept a relationship of any kind (and yes, I have checked its not hidden on another screen!)
I have
I can see that someone posted a similar problem, but those troubleshooting steps did not solve my issue: Solved: Can't create a table relationships - Microsoft Fabric Community
Any help would be greatly appreciated - I have never had this issue before!
Solved! Go to Solution.
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.
Unfortunately, no. If it works on your file and works on mine, it means the issue is likely specific to your data.
Without access to your file, I'm afraid I cannot determine the exact cause.
At this point, it's probably best to open a support ticket with Microsoft.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Thanks so much for trying - I really appreciate the help. Unfortunately I can't send through patient data, but I will open a ticket. Have a great day 🙂
Hi Greg,
Sorry if I wan't clear - there is no ok button. At all. Not even hidden on another page!
Jill
@Jmo_1982 Maybe adjust screen resolution?
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 23 | |
| 23 | |
| 19 | |
| 16 |
| User | Count |
|---|---|
| 62 | |
| 36 | |
| 30 | |
| 25 | |
| 21 |