Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

0

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

Submitted by Anonymous on ‎09-28-2022 01:23 PM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎09-28-2022 07:22 PM

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

 

 

Idea Statuses