Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello team, I have a doubt and I need help. I made a summarized example of my problem, I have 3 tables where I created a key in each one and created a table with SUMMARIZE.
from the relationship I would like to get information from the 3 tables, but when placing the fields it is giving a relationship error
----- > Test.pbix
I can't understand where the relationship error is. Thanks for the help
Solved! Go to Solution.
Hi @Spotto ,
Can't display the data because Power BI can't determine the relationship between two or more fields.'
You are trying to use two or more fields from tables that are not related. You need to remove the unrelated fields from the visual and then create a relationship between the tables. Once you have done this change, you can add the fields back to the visual. Refer: Create and manage relationships in Power BI Desktop
You can refer this simliar issue:
Error: Can't determine relationship between fields
Solved: Can't display the data because Power BI can't dete... - Microsoft Power BI Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Spotto ,
Can't display the data because Power BI can't determine the relationship between two or more fields.'
You are trying to use two or more fields from tables that are not related. You need to remove the unrelated fields from the visual and then create a relationship between the tables. Once you have done this change, you can add the fields back to the visual. Refer: Create and manage relationships in Power BI Desktop
You can refer this simliar issue:
Error: Can't determine relationship between fields
Solved: Can't display the data because Power BI can't dete... - Microsoft Power BI Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
97 | |
80 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |