Date / Time import issue

The Horse

Board Regular
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) ?


The Horse

Some videos you may like

This Week's Hot Topics