Forum Discussion
Anno2019
Helper IV
Helper IVPowerBI not recognising date and time in data
Hi Guru's I have data that is direct from Web Intellegence and one of my fields is in date and time. Web intellegence formats my date and time like this: 7/10/2018 9:43:00 AM When I upload ...
Hi Anno2019
You can not format date to datetime, as date type has no time, you can check when you importing the data if there is no separate time column or if one of the prior steps in Query Editor has not formated the datetime to date in the earlier stages.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
Community Champion
Community ChampionHi Anno2019
You can not format date to datetime, as date type has no time, you can check when you importing the data if there is no separate time column or if one of the prior steps in Query Editor has not formated the datetime to date in the earlier stages.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
If this post helps, then please consider Accepting it as the solution.
