Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I didn't notice the "don't post new issues here" on the old page until I was done posting my two issues, sorry for the duplication:
Salesforce reports time in UTC format with the correct time zone, but PowerBI seems to be misinterpreting the UTC time as the already offset time (it's not applying the UTC offset).
For example, 16:00:00 UTC -5 is seen inside of power BI. In Salesforce this same record shows 11:00AM EST. PowerBI should either be showing 16:00:00 UTC 0, or 11:00:00 UTC -5.
When you try to offset the time with the date/time/timezone functions, you get something like 11:00:00 UTC-10 which then gets adjusted to your local time zone automatically and you're again presented with 16:00:00!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.