Empty datetime values defaulting to 0001-01-01T00:00:00Z in ODATA-feed
PlannedRecently 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.
-
Official comment
This will be solved in the next release which is planned for this weekend!
-
Thanks for your post! Tom de Ridder can you take a look at this?
0 -
Dennis Hoefakker we should take a look at this.
0 -
I'll create a ticket so you can take a look at this Dennis Hoefakker
0
Please sign in to leave a comment.
Comments
4 comments