Not able to get data even after creating many to many relationship

[jatneerjat]

Hi,

I have created relationship like below,in this i have unique dates in date table and other have duplicate date values:

but i am getting below error while i pull the dates of the columns which have duplicate dates:

how can i create a relationship so all 3 of my dates will be in sync?

Thanks,

Neeraj

[v-frfei-msft · Accepted solution]

Hi @jatneerjat,

I created some tables as you described. Based on my test, I can reproduce the issue the same as you by pulling duplicate dates from different tables into one visual.

Actually this is a known issue in Power BI when using groups from a chain of N:1:N relationships. The issue could be fixed by changing the fields from don’t summarize to other options. Also we can work around this issue by adding a model measure to the visual. The DAX generation logic for visual queries treats model measures as if they could relate any combination of groups. Therefore, adding a model measure to a visual effectively disables the check for unconstrained joins that is triggering the error message shown below.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/7ee5dtxkc3zyknk/Not%20able%20to%20get%20data%20even%20after%20creating%20m...

Regards,
Frank

[jatneerjat]

Hi @v-frfei-msft,

It works when i use this date values in slicer but when i drag this into the table then it gives error message as posted by you so i think it worked for me as i removed dont summarize option.

thanks

[v-frfei-msft]

Hi @jatneerjat,

Does that make sense? If so , could you please mark this answer as a solution?

Regards,
Frank