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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors