Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
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}})
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..
Salesforce Company Information Settings
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
22 | |
17 | |
11 | |
10 | |
9 |
User | Count |
---|---|
34 | |
27 | |
19 | |
16 | |
16 |