Execution Time Changes on PBI Service for Paginated report

[abpgupta]

Hi All,

When I run Paginated report in power BI Report Builder, Execution Time parameter shows correct Time as per my TimeZone; however, when it's published to PBI Service and run , I see Timezone way behind.  

Is there any settings or calculation to make it it current Time Zone in PBI Service as well?

Thanks for any inputs!

Regards

Buddhi

[abpgupta]

Thanks @v-robertq-msft ! using UTC FixedNow and Add TimeZone functions, I am able to reflect correct TimeZone on PBI Service as well.   For Day Light Time Zone, I would also need to add calculation based on Month and use in TimeZone Calculation. 

[v-robertq-msft · Accepted solution]

Hi, @abpgupta 

Here’s a method to change the DateTime shown in the report, you can add a custom column in Power query to fix the timezone to local using M query, you can check these two functions:

DateTime.AddZone()

DateTime.FixedLocalNow()

You can try a custom column like this:

Datetime column

=DateTime.AddZone([Utc DateTime], -6)

Here’s a case similar to the Time value shown in Power BI reports, you can take a look and check if it’s useful:

https://community.powerbi.com/t5/Desktop/Date-time-showing-issue/td-p/1558757

Best Regards,

Community Support Team _Robert Qin

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

[abpgupta]

Thanks @lbendlin  for inputs!
Is there any way to know if report is run from PBI Service or from Report Builder? If it's possible, probably I can do calculation to show correct run time. 
Secondly, if there is function to convert TimeZone, that may help here as well.

Please let me know. Thanks in advance. 

[lbendlin]

No, Power BI Service runs on UTC. You can't change that.

You can change the scheduling time zone if that helps.