Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Visharavana
Resolver II
Resolver II

Need help for data model

I have PR, PO, and GR tables. Three tables are connected to the correct relationship. Now I want to connect the dim_date table to these tables, and one issue is that PR, PO, and GR tables have separate dates. I connected dim_date to the PR table date column but was not able to connect to the PO and GR table date columns. It shows an ambiguity problem. How to connect these tables without using USERELATIONSHIP.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vrzhoumsft_0-1728978656660.png

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.

View solution in original post

3 REPLIES 3
Kedar_Pande
Super User
Super User

Instead of having one dim_date table, create separate date tables for each of your tables (e.g., dim_date_PR, dim_date_PO, dim_date_GR). Each of these can have a many-to-one relationship with their respective tables based on their date columns.

 

Connect each date table to its corresponding table based on their respective date columns.
This approach avoids ambiguity and maintains clear relationships for each table.

 

If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande

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?

Anonymous
Not applicable

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.

vrzhoumsft_0-1728978656660.png

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.