Getting Current Time not populating column

[DSwezey]

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 column into a card it just shows the "Count of Year"

Any ideas why no date/time is being populated in my column?

[Anonymous · Accepted solution]

Hi @DSwezey ,

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]

@DSwezey 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.

[DSwezey]

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

DateTime.LocalNow()

[Greg_Deckler]

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

[DSwezey]

It's not being populated at all...

[Greg_Deckler]

@DSwezey 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

[DSwezey]

I tried removing the hierchy but that also did not get any data of a refresh.

[Greg_Deckler]

@DSwezey OK, so what if you go into Power Query Editor, does the date and time show up there?

[DSwezey]

Nope, no date and time show in either the Power Query editor or the visual