Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query convert date to datetime

Hello guys,   The Power Query convert itself all my date (dd/mm/yyyy) columns to datetime (dd/mm/yyyyy 00:00:00). I would like to keep it in the original type without needing to transform the type...
  • HotChilli's avatar
    4 years ago

    So it looks like you have solved the issue which is probably that powerbi has automatic type detection switched on and it's made an assumption of datetime instead of date.  So it's not really a problem, more a nuance.

    But you now seem to have edited the step and everything is good?