Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This issue actually stems from an issue with UTC time not coming through from Salesforce properly. My workaround was to create a new column that adjusts for the time zone properly, and then assemble the date & correct time together into a new column.
This works perfectly in desktop:
CreatedDate_Final = (LeadAndOpportunities[CreatedDate_Day]) + (LeadAndOpportunities[CreatedTime])
but when published, that column is completely blank on web reports. CreatedDate_day is formatted from the imported "CreatedDate" from Salesforce, and CreatedTime is a date/time/timezone column that I'm just taking the "time" from.
Any idea how to get the column to not be blank on the web?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.