Hi,
I’ve got a Prooblem with a Datefield. Within the datasource it is defined as DateTime Offset. The source is connected via Rest API (ODATA) and I use table flattening before importing it into ODX.
Alle Date fields arrive as DateTime2 when loading MetaData except this one field. It is imported as nvarchar. When looking into it, ist looks like a Boolean. True ist set when the field is filled. The rest is just empty.
I’ve already checked if this field has the same datatype as all of the other fields- the set up ist the same.
When I try to set a default value within the table flattening, the source isn’t recognized anymore and I have to reconnect. When I try override Data Types I get the error “... Exception occurred when converting value '' for column name 'd-Istmenge_Enddatum' from type 'String' (precision:-1, scale:-1) to type 'DateTime' ...”
The same error occurs when I try converting it in stage with set custom transformation to replace empty field with a default date.
Maybe some one has encountered a different Problem or has some ideas to resolving the issue.
Thanks in advance.
