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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ohohbudi
Frequent Visitor

Relationship Between 1 Fact Table, 1 View Table with 1 Dim table

Hi guys, I'm from Indonesia & want to ask and need your all help immediately. Thank you

 

I have 1 fact table here : DL_Fact_Kapasitas_Mesin = DL_Fact_Machine_Capacity

I have 1 view table : DL_V_Realisasi_Produksi = DL_V_Production_Realization 

I have 1 dim time table : DL_Dim_Time 

 

and i want to connect "Tanggal Rencana Selesai Proses" which is in Date format (format : MM/DD/YYYY ) in DL_Fact_Machine_Capacity and "Tanggal Rencana" which is in date format (format : MM/DD/YYYY) to time (format ex: MM/DD/YYYY) as follows :

DL_Fact_Kapasitas_Mesin/DL_Fact_Machine_CapacityDL_Fact_Kapasitas_Mesin/DL_Fact_Machine_CapacityDL_V_Realisasi_Produksi/DL_V_Production_RealizationDL_V_Realisasi_Produksi/DL_V_Production_RealizationDim_TimeDim_Time

I can make relation between "time" (in date format) in DL_Dim_Time with "Tanggal Rencana Selesai Proses" (in date format MM/DD/YYYY) 

 

But I cannot make relationship between "tanggal rencana" (in date format) from DL_V_Realisasi Produksi with my DL_Dim_Time and the relationship cannot be activated and appeared that yellow warning.

relation.png

 

Does anybody know how to solve this problem? I need your all help and tutorial how to fix this. Thank you guys

0 REPLIES 0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.