Forum Discussion
Its Regarding about Power BI Data Modelling.
Hi Udhayakumar ,
For your question, I think you can take the following steps:
1. I think you can try to change the resolution of Remote Desktop, and try to choose a larger resolution to ensure the page display is complete.
You can look at this topic, it may help you:
Solved: SAVE and CANCEL buttons are not seen in Power Bi... - Microsoft Fabric Community
2. It ends up being a UI error, so you can press Tab to where the OK button should be and press Enter.
Here's a post with a similar problem to the one you're experiencing, so you can see for yourself:
Solved: no 'ok' button to accept a relationship - Microsoft Fabric Community
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try to close and reopen the file and then try, also before that delete all cache files from File - Options.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
I've tried all possible solutions, including closing and reopening the file, uninstalling and reinstalling Power BI Desktop, and clearing the cache, but the issue persists.
Check for Data Type Mismatches:
Ensure that the columns you're trying to relate have compatible data types. For example, if you're relating dates, both columns should be formatted as dates.
If necessary, use Power Query to modify data types to match.
Verify Column Uniqueness:The column in the "To" table (Calendar table) that you're using for the relationship should have unique values. If not, the relationship cannot be created.
Consider adding a unique identifier column to the Calendar table if needed.
Disable or Modify Filters:If you have filters applied to the tables or columns involved in the relationship, try disabling them temporarily. Filters can sometimes interfere with relationship creation.
Check for Circular Relationships:A circular relationship occurs when two tables are directly or indirectly related to each other in a loop. This can cause issues. Ensure that your data model doesn't have any circular dependencies.
Try Refreshing the Data Model:Sometimes, refreshing the data model can resolve unexpected issues. Right-click on the model in the Power BI Report view and select "Refresh".
Consider Using a Different Relationship Type:If the standard one-to-many or many-to-one relationships aren't working, explore using a one-to-one or many-to-many relationship. However, be aware that these can have performance implications.
Check for Data Quality Issues:Ensure that the data in both tables is clean and consistent. Any inconsistencies or errors can prevent relationship creation.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!