Forum Discussion
Getting Current Time not populating column
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.
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
DateTypeI tried removing the hierchy but that also did not get any data of a refresh.
Anonymous OK, so what if you go into Power Query Editor, does the date and time show up there?
Nope, no date and time show in either the Power Query editor or the visual