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. 

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

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

elliotdixon I guess I would need to know more about what you are trying to accomplish. If I read this correctly, you are in NZ timesone, and your data is being stored in a DC that is 12 hours ahead and the dates are stored in the TZ of the DC? Can you elaborate a bit?