Forum Discussion
Relationship between date columns
Hi, I have custom data connector...Have two dim tables for date and time....and want make relationship with them, from other Fact table....When type of colums for DateKey and TimeKey is Text, in Pow...
Go to "Transform Data" section and before clicking on "Close and Apply" make sure that DateKey has Date format in both tables (not Date/Time) and that TimeKey has Time format on both of them (again, not Date/Time). Then your relationship should be correctly detected but if not, try to drag and drop the related columns of Fact and Dimensional tables.
If a column has Date format but the related one has Date/Time format your relationship woudn't be correctly detected.
Hope it helps!
Basically from custom connector code I already have Date and Time, and I dont need transform data...but it not helping....no autodetection appears.