Date / Time import issue

[The Horse]

Hope somebody can help ?

Am importing a very large Excel database to Power BI, which includes several date / time fields (dd/mm/yyyy hh:mm format)

When I import to Power BI, the time element is set to 00:00 for every entry (though the dd/mm/yyyy is as expected) !

I've checked my Formatting in Power BI, and its set to Date / Time and dd/mm/yyyy HH:mm:ss.

Anyone know why Power BI is ignoring the time element (crucial in my dbase, as changes happen during the day) ?

Thanks

The Horse

 

[MarcelBeug]

Probably your queries import the fields as dates instead of date/times.

 

[The Horse]

Marcel,

Apologies for not replying sooner with thanks - an oversight on my part !

Regards

The Horse