Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
I have a timezone table you can find here. https://github.com/gdeckler/DAXCookbook/tree/master/Ch3
Thanks @Greg_Deckler
but could you explain to me which way to go with this table? It wasn't clear to me.
Regards
Check out the PBIX file in that same repository. There is a recipe for time zone conversion in there.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.