Paginated Report Timezone is wrong

[CarlsBerg999]

Hi,

I'm using a Built-in field "Execution Time" on a paginated report from powerbi report builder. The timezone on the service is wrong. How should i modify the built in field to return an execution time that is 2 hours earlier than the standard built-in "Execution time"? Im a bit lost here on if this is even possible.

Thanks!

[v-rongtiep-msft · Accepted solution]

Hi @CarlsBerg999 ,

We can switch time zone when add a custom column. I have tested it on my local environment.

Click Home >>TransForm data,

Add column>> Custom Column.

I have also found a similar post, please refer to the following topic to see if it helps you.

https://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/m-p/153663

• See this document fr the difernet options , method 3 is your best bet if you are in a zone with daylight saving  https://radacad.com/solving-dax-time-zone-issue-in-power-bi 

Best Regards

Community Support Team _ Polly

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

[amirabedhiafi]

Check the workaround below:
https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/td-p/114120