Forum Discussion

nckpedersen's avatar
nckpedersen
Icon for Helper I rankHelper I
3 years ago
Solved

Incorrect Date/Time between Salesforce Data and Power BI Query

I'm looking at opportunities created in the last week. When I query the Opportunity[CreatedDate] field in Salesforce, I'm receiving a time 6 or 7 hours after the "official" time logged in Salesforce ...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    Hi nckpedersen ,

     

    I had the same issue with Salesforce before. It appeared that what Salesfoce showed on the web was based on the user's Salesforce timezone settings but what it fed into Power BI was based on the server's timezone. I had  to figure out which timezone the server was on then converted it to my locale in Power Query. 

danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

Hi nckpedersen ,

 

I had the same issue with Salesforce before. It appeared that what Salesfoce showed on the web was based on the user's Salesforce timezone settings but what it fed into Power BI was based on the server's timezone. I had  to figure out which timezone the server was on then converted it to my locale in Power Query.