Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have two tables - one that contains material data and one that contains purchase order data. Part of the material data are the classifications showing approved vendors. To create the bridge table I have a columns in both tables that combine the material number and the vendor number, e.g. 12349876 with 1234 being the material number and the 9876 being the vendor number. This is the material_vendor_key.
I link both tables to the bridge table with the cross-filter direction being "Both" for each table. When I try to combine the data into one visual (specifically a table visual) I receive this error: "Can't determine relationships between these fields".
However, I can filter each data set if I add columns from each table to separate visuals and click on an item or by adding any column to a slicer and filtering that way. It's only when I try to add them to a single visual were the interaction fails.
Material data on the right and PO data on the left. Material data item has been selected and is filtering PO data table:
I have similar setups in other reports, so I am not sure why the relationships are not working in this report.
Solved! Go to Solution.
No one does explain it better than SQLBI Team .
Understanding the “can’t determine relationship between the fields” error in Power BI - SQLBI
hope it helps
No one does explain it better than SQLBI Team .
Understanding the “can’t determine relationship between the fields” error in Power BI - SQLBI
hope it helps
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.