Date / Time import issue
Eliminate Pivot Table Annoyances
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

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
  •  

 

 
DMCA.com