Empty datetime values defaulting to 0001-01-01T00:00:00Z in ODATA-feed

Planned

Edwin van Vugt

May 21, 2021 12:08

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.

1

• Official comment

  

  Kim van Rooijen

  June 15, 2021 11:39

  This will be solved in the next release which is planned for this weekend! 
• 

  Kim van Rooijen

  May 31, 2021 07:49

  Hi Edwin van Vugt

  Thanks for your post! Tom de Ridder can you take a look at this? 

  0
• 

  Tom de Ridder

  June 03, 2021 14:03

  Dennis Hoefakker we should take a look at this.

  0
• 

  Kim van Rooijen

  June 14, 2021 11:52

  I'll create a ticket so you can take a look at this Dennis Hoefakker

  0

Please sign in to leave a comment.