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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
PBIROC
New Member

Creating relationship to date table

Hi all:

I have been using the same dashboard for a few years, but all of a sudden the date table unlinked from the other tables - leaving me with an aggregated mess!  I am stumped as to why I'm given the "ambiguity" error when trying to reconnect?  Up until now, the relationships to the date table were created automatically.   Is there something obvious that I am overlooking?  

 

Thanks for any help!Snippet.JPG

3 REPLIES 3
PBIROC
New Member

My apologies!  Hopefully this is better?  There are several tables, however, only "AEM" is unique for each table.  AEM and Line of Business are the only other connections aside from the date table, which now does not connect. Snippet2.JPG  

It's strange, I can't see any realationship with date table yet it is giving ambiguity error. do you have another layout for model relationship where your date table is connected to some other table? 

vaibhavkale570
Resolver III
Resolver III

sorry but can't understand much with the help of snap provided above.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors