Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

0

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

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?

niko_prana_0-1664396493488.png

 

Status: Delivered

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.

vcaitlynmstf_0-1664417997198.png

 

Best Regards,
Community Support Team _ Caitlyn

 

 

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

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.

vcaitlynmstf_0-1664417997198.png

 

Best Regards,
Community Support Team _ Caitlyn