DateTime in Published Report shows as UTC

[Anonymous]

Hello all,

I recently noticed an issue with some published PowerBI Reports in various workspaces not showing the correct times. It seems to be happening with reports that have CDS as the data source.

The PowerBI Report shows DateTime data in my local time (MDT) on the desktop version of PowerBI and note the "Last Date Refresh" Card showing the local time - I only use the Now() formula.

Once I publish the PowerBI Report to a workspace, the report will still show the correct timestamps with the local time. But if I refresh the dataset from the workspace, all the times get updated to UTC:

How can I solve this issue? It seems to happen only with CDS data when refreshing a published report from the workspace.

Thank you.

[amitchandak]

@Anonymous , refer if this can help

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

[GilbertQ · Accepted solution]

Hi there

This is because all the Power BI Servers have their datetime set to UTC. So when using DAX functions that use NOW() for example it will always be in UTC

This blog post explains this as well as how to get it working for your timezone: https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-no...

[Anonymous]

@amitchandak My organization doesn't use Help Shift and we don't have those settings so that link is not helpful. Any other suggestions?

[collinq]

Hi @Anonymous ,

Here is a solution that might be helpful:

https://community.powerbi.com/t5/Desktop/Power-BI-destop-UTC-local-time-and-workspace-has-a-time-gap/td-p/912158

Or this one here:

https://community.powerbi.com/t5/Desktop/Add-UTC-offset-to-client-time/td-p/700640

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!