Forum Discussion
PowerQuery LocalNow() timezone *not* UTC in the service
Thank you for your response, except you missed the key point. When I publish to the service and refresh the data in the service, the results for LocalNow() in PowerQuery are UTC -7, and not UTC as specified in the documentation. LocalNow() returns UTC -7 and UTCNow() returns that actual UTC time. I'm trying to determine how it decides to use that timezone for LocalNow() instead of UTC.
Hi AMD0791
All the servers across Power BI in the world are all set to UTC. So when you are using localnow() and you upload it to the Power BI service it will then use UTC. What I would recommend doing is to offset this with a duration in your PBX so that when it is uploaded to the service it will then correct itself.
+ #duration(0,10,0,0)The code above will add 10 hours to the current Date Time
Thank you for your response, except you missed the key point. When I publish to the service and refresh the data in the service, the results for LocalNow() in PowerQuery are UTC -7, and not UTC as specified in the documentation. LocalNow() returns UTC -7 and UTCNow() returns that actual UTC time. I'm trying to determine how it decides to use that timezone for LocalNow() instead of UTC.