Forum Discussion

Schch's avatar
Schch
Frequent Visitor
2 years ago
Solved

Date Relationships

Hi 

I found the date relationships of tables established before with CalendarAuto() table no longer works.  (it worked normal weeks ago).  When the linkage is removed, it could not be re--established.  Even when I attempt to construct new ones, there is no linkage line appear.  I checked the date types and formats of the tables are intact.  I alos tried Auto detect the relationships, nothing detected.  

 

Any one has similar experience and thought in that?

Stephen

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Schch 

    Here's a similar post that mentions that you can try adjusting your computer's "scale" option.Here are the detailed steps:
    Right-click on your desktop and choose "Display settings." Adjust the options for "scale".

    Solved: issues regarding the manage relationships in model... - Microsoft Fabric Community

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Hi Jayleny,

     

    I reinstall the PowerBi Desktop to the problem PC that I suppose be able to resume normal.  Unfortunately not success.  I checked the display scale of the 2 PCs I tried, the normal one is 125% while my always problem PC is 135%.  So I followed your advice to change the display scale.  You are right.  the scale affects.  But I think it is a bug in this July 2024 version, ( the 2 buttons do not auto-scale and position aligned according to the display scaling),  no such phenomenon in earlier version.

     

    thanks for your clue

    Regards

    Stephen

7 Replies

    • Schch's avatar
      Schch
      Frequent Visitor

      Date Table calendarautotable 1attempt to set up date relationmissing of Save and Canel tab

  • Schch's avatar
    Schch
    Frequent Visitor

    Hi Idrissshatila

    I reckon that it relates to the ABSENCE of Save and Cancel Tab in the New Relationship Page

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Schch 

    Here's a similar post that mentions that you can try adjusting your computer's "scale" option.Here are the detailed steps:
    Right-click on your desktop and choose "Display settings." Adjust the options for "scale".

    Solved: issues regarding the manage relationships in model... - Microsoft Fabric Community

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Schch's avatar
      Schch
      Frequent Visitor

      Hi Jayleny,

      It definitely does not relate to the scaling of the display. 

      The problem Pbix file works fine in a newly upgraded PowerBi desktop version in another PC.  Date relation linkage could be established (with SAVE button)  From there, I made another saved PBix copy back to the problem PC with the PowerBi July 2024 version.  The relationship linkage lines appeared but when I click on the lines for properties display, it shows the relationship page without SAVE and CANCEL Tab.

       

      I reckon the July 2024 version corrupted without notice and not able to self recovered even I attempted to repair and reset the Application in Windows APP install setting.  I haven't try to reinstall the entire PowerBi desktop in order to keep the phenomena for investigation.

       

      Regards

      Stephen

       

       

      • Schch's avatar
        Schch
        Frequent Visitor

        Hi Jayleny,

         

        I reinstall the PowerBi Desktop to the problem PC that I suppose be able to resume normal.  Unfortunately not success.  I checked the display scale of the 2 PCs I tried, the normal one is 125% while my always problem PC is 135%.  So I followed your advice to change the display scale.  You are right.  the scale affects.  But I think it is a bug in this July 2024 version, ( the 2 buttons do not auto-scale and position aligned according to the display scaling),  no such phenomenon in earlier version.

         

        thanks for your clue

        Regards

        Stephen