Forum Discussion
Power BI Data Modeling help needed
Hi Rohit17 ,
I reproduced your problem, in my relational model, because since there is no direct relationship between WP and ET, the visual object does not know how to combine them. This results in an error being reported.
You need to reorganize the relationship between your table, according to the business logic to determine the direction of screening and its relationship, you can refer to the following documents.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
or below blog:
Can’t determine relationships between the fields: bidirectional — Fred's Data Adventure (fpk3.com)
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Rohit17 ,
I reproduced your problem, in my relational model, because since there is no direct relationship between WP and ET, the visual object does not know how to combine them. This results in an error being reported.
You need to reorganize the relationship between your table, according to the business logic to determine the direction of screening and its relationship, you can refer to the following documents.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
or below blog:
Can’t determine relationships between the fields: bidirectional — Fred's Data Adventure (fpk3.com)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly