Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Getting Current Time not populating column

Hi, I want to simply get the current date and time when I refresh my dataset, but I am getting no value when I hit refresh on my table with column: DateTime.LocalNow().   And when I pull this...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I had a test on my side:

    You may click the refresh button to load data:

     

    Actually I could reproduce your issue by following these steps:

     

    So please firstly click the Card visual and drag the Date & Time field to it, you will get the expected output:

     

    Or you could use NOW() to create a calculated column:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Are you sure you pulled in the right column? Because it looks like you pulled in the "Year" column. Otherwise it should say Count of Date & Time.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes I am pulling in my "Date & Time" column which is just:

DateTime.LocalNow()
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous Can I see a screen shot of the Date & Time column in your Data view? Does it have the actual date and time?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It's not being populated at all...

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Anonymous Well, something has to be there or it would not be a count of 365. Oh, try in the visualization pane to wipe out the hierarchy and just use the actual date value perhaps? That's super weird.

         

        Here is a query that I am using in Mastering Power BI 2nd Edition:

        let
    RefreshDateTime = DateTime.LocalNow(),
    TimeZoneOffset = -5,
    RefreshDateTimeAdjusted = RefreshDateTime + #duration(0,TimeZoneOffset,0,0),
    RefreshDateAdjusted = DateTime.Date(RefreshDateTimeAdjusted),
    TableCreate = Table.FromRecords({[CurrentDate = RefreshDateAdjusted]}),
    DateType = Table.TransformColumnTypes(TableCreate,{"CurrentDate", type date})
in
    DateType