cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
spower5 Visitor
Visitor

Paginated reports date and time returns GMT timezone on PBI service

Paginated reports using Globals!ExecutionTime (Built-in Field) or =Now() and =Today() expressions on the Power BI service show the GMT date and time. The date and time for these functions should be the local date and time from the the region of tenant. 

 

E.g If your data is stored in Australia Southeast (Victoria) the date and time shows as GMT+1000 (Australian Eastern Standard Time)

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Paginated reports date and time returns GMT timezone on PBI service

@spower5 ,

 

Actually, functions like now() will return UTC time on service, please refer to case and workaround below:
https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/td-p/114120

 

Regards,

Jimmy Tao

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Paginated reports date and time returns GMT timezone on PBI service

@spower5 ,

 

Actually, functions like now() will return UTC time on service, please refer to case and workaround below:
https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/td-p/114120

 

Regards,

Jimmy Tao

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,522)