Forum Discussion
Date table created data types set in power query cannot create relationship in the model
Can anyone provide guidence. I have created a data table in the model in powerquery and confirmed data types in the date table and in the 2 fact tables are date types. I cannot create a relationship and can't figure out why. I have had no issues previously. Many thanksCan't create relationship
Hi FelixElliott ,
Thanks for the reply from Shravan133 , please allow me to provide another insight:
Check your display settings, especially if you're using a high DPI setting or multiple monitors. Sometimes UI elements may not render correctly if the scaling is set too high.
If none of the above steps work, consider reinstalling the latest version of Power BI Desktop. This can fix issues caused by a corrupted installation. Download address: Download Microsoft Power BI Desktop from Official Microsoft Download Center
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI changing the display settings on the computer fixed the problem.
6 Replies
whats the error?
Few things to consider:
Make sure all your date fields are of teh same datatype, same format
Did u mark your table as date table?
Hi Shravan, yes data types set to date in power query and date table marked as date table. As a check I used a previous report with fully functioning date relationships and deleted a relationship between date table and fact table. I was then unable to re-establish the relationship. Any idea why this would be happening? Thanks
Hi as you can see in the picture I posted the ok and cancel buttons are missing from the manage relationships dialogue box. Does anyone know why?
Hi FelixElliott ,
Thanks for the reply from Shravan133 , please allow me to provide another insight:
Check your display settings, especially if you're using a high DPI setting or multiple monitors. Sometimes UI elements may not render correctly if the scaling is set too high.
If none of the above steps work, consider reinstalling the latest version of Power BI Desktop. This can fix issues caused by a corrupted installation. Download address: Download Microsoft Power BI Desktop from Official Microsoft Download Center
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi FelixElliott ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI changing the display settings on the computer fixed the problem.
