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)
Super User
Most Valuable ProfessionalHi Frixel , amitchandak ,
as far as I know the function DateTime.LocalNow() in the service determines the UTC time. In Power BI Desktop you get your local time zone.
I have not yet found a satisfactory way to display this correctly in the service.
The model language refers to the semantic model, but the cause of this problem lies in the data preparation by Power Query.
- Frixel
Hi 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?
- mwegener
Hi 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.
