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.
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.