Forum Discussion

sjelting's avatar
sjelting
Frequent Visitor
2 years ago

Using User Locale (TimeZone) while refreshing via gateway

Is this possible?

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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's avatar
      sjelting
      Frequent Visitor
      2 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.