Timezone data incorrect

[Anonymous]

I have been manipulating timezone data for my reports on the desktop app but the data I have extracted (from Salesforce) appears differently when I publish the report to the cloud service and refresh the data.

The desktop extract displayed in datetimezone format includes +01:00 for the times captured during British Summer Time

Desktop

When I publish the report to the cloud service the data is displayed identically - but when I refresh the data it changes.

I have copied the same power query to a dataflow on the service and it shows the data differently.

Service

As the timezone on the first record is wrong/missing (+00:00) I cannot correct for the timezone difference. 

Is there anything I am missing?

[Anonymous]

Hi  @Anonymous ,

The time display is different between Power BI Desktop and Power BI Service, the time displayed on Power b Service displays the time according to UTC(), while Power BI Desktop displays the computer's system time.

You can try to add a + time() function after your time measure to display the time in your local time zone to the power bi service.

For example: now()+TIME(8,0,0)

This is the related document, you can view this content:

Solving DAX Time Zone Issue in Power BI - RADACAD

Power BI Service Time Differences and How to Fix It (linkedin.com)

Best Regards,

Liu Yang

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

[Anonymous]

Hi Liu,

Thanks for taking the time to respond. I was aware of that issue and of one of the articles, but thanks for sharing. I am not using a local machine time, rather accessing data from an external source. I use the same query, connection and credentials in both desktop and server scenarios. I see no reason why there should be any difference, even if I was in a different timezone to the server (and I am not). The server data just seems wrong and I'm tempted to call it a bug