Hi Eri,

You are getting this issue because while joining the tables in the data model, it is not able to establish a 1:N relationship.

Here in your case, you have duplicates on both sides Dimension Table(1) as well as in the Fact Table (N).

Your Dimension table is Table A and Fact Table is Table B.

Try applying the Best practices while joining tables in a Data Model. (More can be found in the help section"Data Model Best Practices")

Screen Shot attached.

Hope this helps.

Regards,

JayB

@z.b  Hi, thank you for your reply and helpful information. The problem was resolved! I really appreciate your help.

How did you fix this issue?

I would like to know the resolution. I am having the same case and could not solve yet :(

Hello! I am also experiencing this issue in our environment and the link to the Best Practices has been deprecated, can someone link to the current location of it?