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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Ardio
Helper I
Helper I

Can't determine relationship between fields - although indirect relationship exists

Hi everyone,

I have run into a weird error that I will explain here: 

I have a model with couple of tables connected with each other thorugh  the fields that I have shown in the picture:

Ardio_0-1691593553811.png

Although the table "Circulum unpivot" and "Course_ScheduleNew" are connected as per the screenshot and also "Circulum unpivot" and "Facilitators_courses_list" are also related indirectly but I get the following error when I try to visualize them on the same visual:

Ardio_1-1691593728370.png

I would highly appreciate your help!

Thank you

2 REPLIES 2
amitchandak
Super User
Super User

@Ardio , can you share what field you are taking from which table

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak already showed it on the screenshot:

From CURRICULUM UNPIVOT to COURSE_SCHEDULENEW using Course_name

From COURSE_SCHEDULENEW to FACILITATORS using trainers to Superusers(Faciliratotrs) 

From FACILITATORS to FACILITATORS_COURSE_LIST using Superusers(Faciliratotrs)

Thank you again in advance!

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

Top Solution Authors