Linked date hierarchy blank after scheduled refresh

charliecronin — Wed, 15 Nov 2023 10:23:20 GMT

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")

)

Re: Linked date hierarchy blank after scheduled refresh

josef78 — Thu, 16 Nov 2023 21:16:21 GMT

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.

topic Re: Linked date hierarchy blank after scheduled refresh in Report Server

Linked date hierarchy blank after scheduled refresh

Re: Linked date hierarchy blank after scheduled refresh