Creating relationship fails with no error message or other output

[hmpslrssn]

Hi,

I've got a report with a Date table and a calculated table with a Date column and a custom date range column (YTD,MTD,etc..).

When I try to create a relationship between the Date columns in both tables it looks like the operation is successful, the "Working on it" popup shows and then the "Manage relationships" window shows but with no relationship created.

This is the code for the calcualted table

I tried adding the calculated table to one of my existing models but could not create the relationship. I tried creating a report with only the Date table and the calcualted table but could not get that to work either.

I've never encountered an issue like this before and I'm not sure how to further troubleshoot.

Any help would be appreciated.

Cheers

[gtiwari11]

Hope this issue has been solved?

[gtiwari11]

Hope issue has been solved if not please let me know

[hmpslrssn]

I've nailed the issue, if I pass a CALCULATED value as a parameter to the CALENDAR function it will no longer allow me to create a "one to many" relationship. It only affects one to many relationships.

PBIX file available here: https://www.dropbox.com/s/odcnk3r46zjbtpl/FailedRelationshipDemo.pbix?st=0viw1k4b&dl=0

[v-nmadadi-msft]

Hi @hmpslrssn ,
We really appreciate your efforts and for letting us know the update on the issue.
If you believe this solution has resolved your issue, please mark your reply as the accepted solution to assist other community members who might encounter the same problem in the future.

Please continue using fabric community forum for your further assistance.
Thank you

[hmpslrssn]

I've done some more testing and it seems to only be an issue with the one to many relationship type. There are no duplicates in my Date table but I am able to create a many to many relationship without issue, but if I try to change the relationship type to "one to many" it does the same thing, it does a quick load and then nothing happens. No error and no change.

I've created two other tables for testing as well, one where I manually input 4 dates in a column called Date with 2 duplicates, this table can create the "one to many" relationship with no issue.

The second table is a calculated table where I union two sets of dates with some overlapping dates, this table can also create the "one to many" relationship with no issue.

This is the code for the table that won't work

A screenshot of the relationships with the two test tables.

[gtiwari11]

Try to share pbix to check

[gtiwari11]

Relationship error screenshot please.

Before must check following things:

- Duplicate values

- Data Type

- match date in two different tables try to validat those things then please follow Type of relationship:

one  to many,

Many to one,

many to many

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

[hmpslrssn]

I'm not getting any errors. It just completes the process as if the relationship has been created but there is no relationship there.

[jones1jm]

I have the same problem. Its only been since the last revision of PBI.

[gtiwari11]

Please Share pibix to check (similar issue I've went through where I have found the data Type issue ( not all few)

[hmpslrssn]

I was able to upload the PBIX-file to DropBox, 

https://www.dropbox.com/s/odcnk3r46zjbtpl/FailedRelationshipDemo.pbix?st=0viw1k4b&dl=0