Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI - Salesforce Timestamp Issue

Hello,   In Power Bi Desktop I am getting data from Salesforce Objects (Case Table). Whenever the data is imported the timestamps on the dates are 5hrs ahead of time, which is throwing off our metr...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

How many hours is there between your local time and UTC time? Service server uses UTC time.

Try to add such a column in 'Edit Query'.

 

Best regards,
Lionel Chen

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello, there is a 5hr difference. For performance reasons, is there a solution without having to create a new column? 

     

    • AndrewKuharich's avatar
      AndrewKuharich
      Regular Visitor
      3 years ago

      Hi Anonymous - Did you ever come up with a workable solution for this? I'm pretty new to PBI and I'm experiencing the same issue. Thanks!