Date change when importing a salesforce object via data flow

[Anonymous]

Hi all 

I have a big problem. But I hope you can find a solution.

I recreated the entire data model I had connecting directly to salesforce objects, instead of connecting to Excel reports and spreadsheets.

I used the data flow.

However, when bringing the data, the date does not match the local date.

For example, a sale was closed on 1/31/2020 at 8:34 am and when you bring that sale up, the date appears as 2/1/2020 at 11:34 am.

Is there a possibility to correct this

best regards

[v-gizhi-msft]

Hi,

Please try to use UTCNOW or UTCTODAY function.

Hope this can help.

Best Regards,

Giotto Zhi

[Anonymous]

Thanks

but could you explain to me which way to go with this informantion? please... should I use in each date field? for example?

regards

[Greg_Deckler]

I have a timezone table you can find here. https://github.com/gdeckler/DAXCookbook/tree/master/Ch3

[Anonymous]

Thanks @Greg_Deckler 

but could you explain to me which way to go with this table? It wasn't clear to me.

Regards

[Greg_Deckler]

Check out the PBIX file in that same repository. There is a recipe for time zone conversion in there.

[Anonymous]

@Greg_Deckler I appreciate your patient and help.

I went searching and found that the date, in salesforce, actually writes to the table considering UTC. And for each org / user there is a timezone that converts that date to salesforce reports and layouts.

As I imported the table, the recorded value of the date is actually in UTC, and I am in UTC -3 hours.

Here is the same scenario that I am experiencing.

https://community.powerbi.com/t5/Issues/Time-zone-issue-with-Salesforce/idi-p/97839/page/2#comments
And it seems that there is still no solution.

Even looking at the file you indicated, I couldn't identify how to get around it. I keep searching.

Best regards