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.
Yes I am pulling in my "Date & Time" column which is just:
DateTime.LocalNow()
Community ChampionAnonymous Can I see a screen shot of the Date & Time column in your Data view? Does it have the actual date and time?
It's not being populated at all...
- Greg_Deckler
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.