Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
malex30
Frequent Visitor

Salesforce Object Timezone change

I have a report that is connecting to a salesforce object (and two dataflows from within Power BI Service Workspaces).
The data coming straight from the Salesforce Object contains the date.time columns in question. 


1. Here is a sample from a Salesforce Object: This is the "Original" value I'm trying to match when shown inside a Power Bi Report SalesforceObject.jpg

 

 

2. Here is a sample once connected to a Power Bi Desktop Report. 
You are seeing four columns
1. "From__c" (Column name from Saleforce Object from the previous picture "Start Date/Time" )
2. "Start Date/Time" (a column I added within Power Query based on the "From__c" column)
3. "To__c" (Column name from Saleforce Object from the previous picture "End Date/Time" )
4. "End Date/Time" (a column I added within Power Query based on the "To__c" column)

You should notice the "From__c" and "To__c" (coming from the actual fields from the Salesforce Object") don't even reflect the correct date/time from Salesforce inside the Power Bi Desktop. This is the reason I added the two new columns I've named the same name corresponding to the Saleforce object ( i.e. "Start Date/Time" & "End Date/Time")

Lastly you'll notice the "Start Date/Time" and "End Date/Time" (the ones I added inside Power Query) no reflect the "Start Date/Time" and "End Date/Time" from the Salesforce object. 

Here is the formula steps I performed to create these columns

= Table.AddColumn(Job_Activity__c, "Start Date/Time", each DateTime.AddZone([From__c], -1))
= Table.AddColumn(#"Added Start Date", "End Date/Time", each DateTime.AddZone([To__c], -1))
= Table.TransformColumnTypes(#"Added End Date",{{"Start Date/Time", type datetime},{"End Date/Time", type datetime}})

example_PowerBiDesktop.jpg

 
3. Here is a sample once connected to a Power Bi Service Report. 
Once published into a Power Bi Workspace you will the columns I added inside of Power Query are now wrong..  

example_PowerBiService.jpg

 

 Salesforce Company Information Settings

 

Salesforce_CompanyInfo.jpg


Please help me figure out this issue. 
Keep in mind we have jobs performed from different timezones and we want to reflect the timezones time. NOT our current local machines' time relative to that timezone. 

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.