Linked date hierarchy blank after scheduled refresh

[charliecronin]

Hi there

I have a PBI report on our hosted PBI server. It is scheduled / updated nightly. I have a table (on left in image below) that has a Key and Last Updated fields. The Last Updated field has a relationship to a Date table that is created by a DAX (see code snip-it further below) and provides a hierarchy for Year/Month/Day. When you look at the table you can see the Year/Month/Day are blank.

When I edit the PBI file in the Desktop app the table gets populated as I would expect (see image below). If I save the report all looks good on the PBI server but when the report is scheduled/updated the table reverts back. Any ideas why this is?

Thanks for your time.

Charlie

Date =

VAR BaseCalendar = CALENDAR(MIN('Autotime Query'[Week Worked]), MAX('Autotime Query'[Week Worked]))

RETURN

    GENERATE (

        BaseCalendar,

        VAR BaseDate = [Date]

        VAR YearDate = YEAR(BaseDate)

        VAR MonthNumber = MONTH (BaseDate)

        RETURN ROW (

            "Day", DAY(BaseDate),

            "Year", YearDate,

            "Month Number", MonthNumber,

            "Month", FORMAT (BaseDate, "mmm")

        )

    )

[josef78]

I'm not sure, but take care about full date value (include time part). Because power query can shift time part of date, if server is configured in different time zone.