Results 1 to 2 of 2

Thread: Retrieve Date and Time format from appended queries
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Retrieve Date and Time format from appended queries

    Hello,

    I am new with PowerBI and not sure if this is even possible.

    I have a main table/data model which I appended multiple months of data (different tables per month, which I append tables per month). A column on the data model had originally a Date and Time format which I changed the format to Date only (this is the only format I used for a couple of months now). I then unchecked the "Enable Load" on the previous months which I did not realize that there would come a time that I would need to have the time along with the date to measure the time interval.

    Steps I have tried to retrieve the data :
    1. I have tried to change the format to Date and time in the data model but it only gives me 12:00:00 on all rows.
    2. I have checked the "Enable Load" then refresh power query and the main page, but it is still showing 12:00:00
    3. I tried deleting the steps of "change type" on the applied steps on the power query, but no good.

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Retrieve Date and Time format from appended queries

    Hello,

    First thing is to make sure you are dealing with Values ... and not Text ...

    You can see Dates and Times ... but the display is misleading ...

    Hope this will help

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
  •