Put fields from three tables in one report, report will broke and say "no relationship detected"

[Anonymous]

When we put fields from three tables in one report altogether, the report broke and says "no relationship detected". But fields from any two tables of the three would be okay with no errors. We'd like to get some hints or suggestions on what is probably going wrong?

[v-xiaoyan-msft]

Hi @Anonymous ,

What you need is to change  cross filter direction of the relationship between Table 'Events‘ and ’DataTable‘ to  'Both'. 

And then you need to make relationship among these table or make relationship that you don't need now inactive.

Best Regards,
Community Support Team _ Caitlyn