Empty datetime values defaulting to 0001-01-01T00:00:00Z in ODATA-feedPlanned
Recently we noticed that datetime values in PowerBI based on the BlueDolphin ODATA-feed are defaulting to 0001-01-01T00:00:00Z when empty. This results in PowerBI reports showing the date 30-12-1899 as a value for empty records. Which is strange, as datetime columns can and will also contain null values (as is the correct behavior). Contact with a consultant resulted in the explanation that it's not a bug, but a feature. They suggested I post a wish on this board to change this behavior.
While I'm still convinced this is a bug, here it is: empty datetime values should default to null, not to a dummy datetime value.
Please sign in to leave a comment.