Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Date / Time import issue

  1. #1
    Board Regular
    Join Date
    Feb 2004
    Location
    Dublin
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Date / Time import issue


    Date / Time import issue
    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

  2. #2
    Board Regular MarcelBeug's Avatar
    Join Date
    Apr 2014
    Posts
    1,811
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date / Time import issue

    Probably your queries import the fields as dates instead of date/times.
    Specializing in Power Query (M).
    Using Excel 2007 (Dutch) and Excel 2016 (Office 365 ProPlus) (Dutch/English), both on Windows 10.
    Array formulas can be recognised by the {} Excel puts around it automatically when you press Ctrl+Shift+Enter upon formula entry.

  3. #3
    Board Regular
    Join Date
    Feb 2004
    Location
    Dublin
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date / Time import issue

    Marcel,

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

    Regards

    The Horse

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •