A data refresh with Gateway Enterprise changes date from 00001-01-01 to 1899-12-30

[louagej]

Hi,

When my report is prepared and published, I have a colum with Estimated Date of Arrival showing me a Date. Where my date is 0001-01-01, the report shows an empty Date.

This is how I also want it to be shown.

After a data refresh from the Gateway

the report suddenly shows another Date: 1899-12-30.

What can I do to keep the date empty?

[v-caliao-msft · Accepted solution]

@louagej,

As smoupre said, you could create a calculated column to work around your issue. Sample DAX.
Column = IF(YEAR(Table2[Date])<1900,BLANK(),Table2[Date])

Regards,

Charlie Liao

[louagej]

The Calculated column indeed creates a workaround.

Thanks for the replies.

[Greg_Deckler]

That seems like a bug. That date is the base date in Power BI. You should be able to fix it in Power BI (work-a-round) by creating a calculated column in either M or DAX.