Forum Discussion
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...
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.
I 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