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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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