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.
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!
Solved! Go to Solution.
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
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
Get Date = NOW() is not known in the latest version of the Power BI client
Time will not refreshed automatically without refreshing the dataset, else you can use direct query and enable Last Refreshed in dashboard tile.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |