Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
melina
Helper IV
Helper IV

Display current date and time

Hi all,

 

I want to show current date and time in my report and dashboard. I have use measure DateTime = NOW()+ (8/24). But when i view in my report, the system show wrong current time. It only correct when i published to the web services, but still need to refresh every time. Is there any alternative way if i want to show correct current date and time in report and  web services without need to refresh everyime?

 

Thanks!

1 ACCEPTED SOLUTION
rommel20
Resolver I
Resolver I

Create Column instead of measure 

 

[Column]   Get Date = NOW()

[Measure]   Last Date Refreshed = "Last Refreshed :" & MAX(Table[Get Date]) + (10/24)

 

+ 8/24 - for  beijing, hongkong etc.

+10/24 - for autralia 

etc. etc.

 

note* it will work in PowerBI Service, if you refreshed on your desktop it will give incorrect value since you add 8 hours.

 

Desktop : now () = local time
Service : now () = UTC time

 

 time.JPG

 

View solution in original post

4 REPLIES 4
rommel20
Resolver I
Resolver I

Create Column instead of measure 

 

[Column]   Get Date = NOW()

[Measure]   Last Date Refreshed = "Last Refreshed :" & MAX(Table[Get Date]) + (10/24)

 

+ 8/24 - for  beijing, hongkong etc.

+10/24 - for autralia 

etc. etc.

 

note* it will work in PowerBI Service, if you refreshed on your desktop it will give incorrect value since you add 8 hours.

 

Desktop : now () = local time
Service : now () = UTC time

 

 time.JPG

 

Get Date = NOW() is not known in the latest version of the Power BI client

rommel20
Resolver I
Resolver I

Time will not refreshed automatically without refreshing the dataset, else you can use direct query and enable Last Refreshed in dashboard tile.

Capture.PNG

 

i already refreshed my dataset, but in my report, the time not show current time. Supposedly for cuurent time it will show 10.24 a.m

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.