Forum Discussion

JuliaYebra's avatar
JuliaYebra
Helper III
10 years ago
Solved

Powerbi.com Server Time

I have a report that works well on Power BI Desktop but on the Service shows wrong values.   This is because when using now() function on Desktop shows my country time correctly but on Service it s...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    JuliaYebra You can tell where you data is being stored by clicking on the question mark in the upper right hand corner, and selecting "About Power BI". This may help in troubleshooting. 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

JuliaYebra You can tell where you data is being stored by clicking on the question mark in the upper right hand corner, and selecting "About Power BI". This may help in troubleshooting. 

  • elliotdixon's avatar
    elliotdixon
    Responsive Resident
    10 years ago

    Hi Anonymous I have the same issue on all my reports.

    Data is being stored in Singapore under NZ timezone

    however as you can see it still thinks it is yesterday ! New Zealand is +12 hours.

     

    Any fix for this you can recommend would be great.

    Cheers

    ED.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      elliotdixon If you take the current time in the NOW() function and subtract the time as a fraction of 1 day you can remove hours. So, 1 day = 24 hours. 1/24 * (number of hours you want subracted) will be the decimal that you subtract. This should give you the local time you want to display in your reports when using the NOW() function. Here are some quick examples, you'll notice the 22 hours ago correctly moves you back a day.

       

      • elliotdixon's avatar
        elliotdixon
        Responsive Resident
        10 years ago

        Hi Anonymous Thanks for this - helps a bit. I have been using the format

        NZ Now = NOW()+(12/24)

        Which gives +0.5. Excatly what you have. Which is great.

         

        Issue is that now its the afternoon in my time the dates are still looking +0.5 of a day ahead. Means I am getting numbers for Friday when it is still Thursday. Any ideas how this can be fixed?

         

        Cheers