Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am getting the error "can't determine the relationship between fields", when adding a column to a report.
I have the following data sets:
The ERD is shown below.
The relationships are shown below.
If I add any column from Insurance_Order_Details, Insurance_Order, or Insurance_Policy, I get the error.
This is a problem because I need to add colums from all of those.
What do I need to do?
Any guidance or recommendations would be appreciated.
Solved! Go to Solution.
Hi @ACECEO
It is important to distinguish dimension table and fact table in your data model.
Instead of putting all the tables side by side as shown in your screen print, the best practice is to put the dimension tables above the fact tables so that you can clearly see the direction of filters flowing down from dimension tables to the fact tables (one side of the relationship to many side of the relationship).
Best regards,
Hi @ACECEO
It is important to distinguish dimension table and fact table in your data model.
Instead of putting all the tables side by side as shown in your screen print, the best practice is to put the dimension tables above the fact tables so that you can clearly see the direction of filters flowing down from dimension tables to the fact tables (one side of the relationship to many side of the relationship).
Best regards,
Thanks. I completely overhauled the relationsips to fix the issue. I am all set now.
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |