Skip to main content
Microsoft Idea

Power BI

Needs Votes

Minor bug when creating a date table using CALENDARAUTO with a one-to-one relationship

Vote (1) Share
michael's profile image

michael on 09 May 2019 00:54:23

When a date table is created using the CALENDARAUTO () function against a table that has unique dates and then a relationship is created between the two tables by dragging the date column in the date table to the date column in the "fact" table then an error is returned saying that a circular dependence was detected, if the relationship is created in the other direction then no error is thrown (which is correct). this only happens when the relationship would be one-to-one