PBI Service refresh setting dates UTC causing local display issues.

v-kelly-msft I will try to create the example today but here are screen shots of the issue.

This is the table of contract lines. Note rows 1 & 2 show MonthDate (type Date) with pro rated values of 1. That means its a full month, the measure takes the revenue and multiplies by the pro rated amount. There are no rows for Month Sept.

Here is the report which has been refreshed by the service. Note the revenue being reported in Sept for product 3.01 & 3.02

I refreshed the dataset locally on PBI desktop and published the report, note the report correctly shows 0 revenue for Sept. As soon as it completes the refresh process after publish it reverts to reporting an hours revenue in Sept.

Ive also checked queries. The col MonthDate is created by the custom function initially as text. I convert it to a date. Its never been a formatted datetime.

I think the issue is coming from the Calendar table. Its a generated list of dates and correpsonding cols. Although again the cols are always just dates so timezone should'nt be a factor however im assuming because its being created by the service some localisation is being applied.