Using User Locale (TimeZone) while refreshing via gateway

[sjelting]

Is this possible?

[Anonymous]

Hi @sjelting ,

Time Zone Differences:
Power BI Desktop and Power BI Service handle time zones differently.
In Power BI Desktop, the time zone is influenced by your local system settings, which is why you see the date in your locale timezone (3pm +01).
However, in Power BI Service, the time zone is always UTC. This means that regardless of where the data center hosting your Power BI tenant is located, the service will use UTC for all calculations and time-related functions.

Although Power BI Desktop adapts to the local time zone, the Power BI service always uses UTC To ensure accurate results, adjust your calculations accordingly.

Below is the link will help you:

Solved: timezone corrections on power BI service not the s... - Microsoft Fabric Community

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please be more specific.  Refresh scheduling can be expressed in "local"  timezones.  But behind the scenes everything is always UTC.

Or do you mean something different?

[sjelting]

I have a date in my database (2pm, UTC), which when i view it in PowerBI Desktop gets shown in my locale timezone (3pm +01), but if i publish it and refresh it via gateway, it is shown in PowerBI Service as 2pm, UTC.