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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.