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.
Hello all,
I am connecting Power BI to SQL tables, table relatationships as below.
I am trying to create a table visual with Group (from application master) and sla-measured (from summary) and sla-target (from target) when I choose don't summarize option it gives error as - Can't determine relationship between the fields.
Solved! Go to Solution.
Hello @gary5
In addition to amitchandak's response, this error can be caused by one to many relationships.
You can create relationships between the Summary table and the Set Table directly (many to many)
Inactive this relationship:
You can create a measure and add some other columns (number type) to the Tagert table in this table visual table and demmarize this column.
Or you can activate this relationship and delete relatioshipe with App Table.
And add a calculated App_Group in Summary or Target Table.
App_Group = CALCULATE(MAX(App_Master[APP_Group]),FILTER(App_Master,App_Master[APP_ID]=SLA_SUMMARY_DETAIL[APP ID]))
Result:
Best regards
Rico Zhou
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hello @gary5
In addition to amitchandak's response, this error can be caused by one to many relationships.
You can create relationships between the Summary table and the Set Table directly (many to many)
Inactive this relationship:
You can create a measure and add some other columns (number type) to the Tagert table in this table visual table and demmarize this column.
Or you can activate this relationship and delete relatioshipe with App Table.
And add a calculated App_Group in Summary or Target Table.
App_Group = CALCULATE(MAX(App_Master[APP_Group]),FILTER(App_Master,App_Master[APP_ID]=SLA_SUMMARY_DETAIL[APP ID]))
Result:
Best regards
Rico Zhou
If this post helps,then consider Accepting it as the solution to help other members find it faster.
@Anonymous , If Table C is Common Table For A and B . means C- A (1-M) and C-B(1-M)
then you can take unsummarized columns from C and either from A or B, not both.
@amitchandak Then what should we do if we want to display unsummarized columns (using Don't summarize) for both tables in a "Table Visual".
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.