Date Relationships

[Schch]

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

[v-jialongy-msft · Accepted solution]

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.

[v-jialongy-msft · Accepted solution]

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]

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 · Accepted solution]

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

[Schch]

Hi Idrissshatila

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

[Idrissshatila]

Hello @Schch ,

it seems like a bug.

can you open an issue with what are you facing in the following link and microsoft support will investigate it and report it to the production team for fix.

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

[Idrissshatila]

Hello @Schch ,

this is weird, try creating a new dim_date table and link it with the facts. 

[Schch]

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