Forum Discussion

Jeanobelo25's avatar
Jeanobelo25
New Member
5 years ago

time zone correctiontime

Can someone help me? when I'm on power bi desktop the time is right, but when I put it on power bi service it gets 3 hours more, how to fix it?

Tips and Tricks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Jeanobelo25 Check what time zone your tenant is in. What functions are you using? TODAY? NOW? 

     

    In the Service, the ? in the upper right and then About Power BI

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Jeanobelo25 ,

     

    You can view the time zone of the service in the following ways:

     

    On Power BI Service, we can't set the time zone on Power BI Service. To get the correct local time, we can add time different in your DAX formula, or use Power Query to get the local time zone datetime.

     

    For example, the following way:

     

    Reference document link:

    DateTime.AddZone - PowerQuery M | Microsoft Docs

    Solving DAX Time Zone Issue in Power BI - RADACAD

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

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