Forum Discussion
Need help for data model
Hi Visharavana ,
As far as I know, Power BI Desktop allows only a single active relationship between two tables at a given time.
Currently, you want to create the relationship between PR, PO, GR and DimDate table.
From above sample relationship, we find that there are two active relationship between Date and PO.
DimDate -> PO
DimDate -> PR -> PO.
So Power BI will return error until you inactive one relationship.
For reference:
Understanding Ambiguity in Power Data Model - Microsoft Fabric Community
Create and manage relationships in Power BI Desktop - Power BI | Microsoft LearnBest Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your fast response.I want to use one date for the whole report. That's why I created dim_date. Your given idea does not fit this scenario because I want only one date column. That column filter used the whole report. Is there any other possible way?
Hi Visharavana ,
As far as I know, Power BI Desktop allows only a single active relationship between two tables at a given time.
Currently, you want to create the relationship between PR, PO, GR and DimDate table.
From above sample relationship, we find that there are two active relationship between Date and PO.
DimDate -> PO
DimDate -> PR -> PO.
So Power BI will return error until you inactive one relationship.
For reference:
Understanding Ambiguity in Power Data Model - Microsoft Fabric Community
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.