Forum Discussion
Post ProdigyRefresh DateTime not always works
Frixel ,
you can also try the following API call.
Showing Specific Timezones in Power BI Service (Last Refreshed Time)
Post ProdigyHi mwegener
I thought i have the right time in the service. It is so when i publish the report from desktop to service then i have the right time.
But when the report in service refresh (schedule or power automate trigger) then the time is again in the past.
If i understand you right then that is a issue of the service version and is not to solve by my as a noob?
Most Valuable ProfessionalHi Frixel ,
at the time you deploy the report from the desktop to the servicer, the report still contains the data obtained on your local machine (local time zone). When the report is updated for the first time in the service, it determines the data in the service (UTC time zone).
https://docs.microsoft.com/en-us/powerquery-m/datetime-localnow
DateTime.LocalNow() as datetime
Returns a datetime value set to the current date and time on the system.
You would have to convert the UTC time to your time zone, which is not easy due to the daylight-saving time.