Time From Salesforce Object Shows -05:00 and -04:00 when Date/Time/Time Zone is Selected in Power BI

[Anonymous]

Hi Everyone,

I am importing leads from Salesforce as an object. I have successfully converted the time from Power Bi's standard UTC time to my time zone, which is EST time. But, I am confused as to why some of the values showed up as -05:00 and why some are showing -04:00. My Salesforce account automatically converts times to EST from GMT, which is -04:00, but I cannot figure out why some of these values show up as -05:00 in power bi. 

Here is a photo of the time zone in Salesforce and here is a photo of the values in Power BI

Any ideas or suggestions are greatly appreciated

[lbendlin · Accepted solution]

That entirely depends on who modified these records, and the timezone they were in.

[lbendlin]

Your current timezone is not EST, it is EDT.  Please read the documentation for ISO-8601 and then continue what you are doing (ie base EVERYTHING on UTC).

[Anonymous]

thank you for pointing that out, that is a good point. but why are some of the values rolling back 5hrs and some rolling back 4hrs? Shouldn't they all be rolling back 4hrs from gmt/utc to edt?