cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CloudMonkey Member
Member

Mapping date field to date/time field

Hi,

 

I need to map a date field to a date/time field. Using query editor I tried changing the data type of the "date/time" field to "date". But when I try to map the two tables together I get a dotted line (i.e. there are no relationships). I've got through the two fields and there are definately the same dates in each field. Please can you tell me how to fix?

 

Thanks,

 

CM

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Mapping date field to date/time field

@CloudMonkey,

 

Hi CM,

 

If you got a dotted line, you have gotten a relationship that is inactive. Because only one relationship is active at a single time. Please check it out.

 

You mentioned there are no relationships. Please try to active it manually.

If the issue is still there, please provide your .pbix file. At least a sample and some snapshots.

 

Mapping date field to datetime field.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Mapping date field to date/time field

@CloudMonkey,

 

Hi CM,

 

If you got a dotted line, you have gotten a relationship that is inactive. Because only one relationship is active at a single time. Please check it out.

 

You mentioned there are no relationships. Please try to active it manually.

If the issue is still there, please provide your .pbix file. At least a sample and some snapshots.

 

Mapping date field to datetime field.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CloudMonkey Member
Member

Re: Mapping date field to date/time field

Thank you @v-jiascu-msft when I went to the "Edit relationship" window in your screenshot there was a message telling me the relationship was inactive because it was conflicting with another relationship. I incorrectly assumed the dotted line meant the data formats were not compatible. But I see now that Date fields can be mapped to Date/Time fields.

 

I removed the other conflicting relationship and it now works.

 

Thanks,

 

CM