Forum Discussion
Could not determine JSON object type for type Microsoft.DataTransfer.DataTypes.Date.
No. I have a workaround: converting the column to string in the Data Flow.
However, I do not want that workaround. I expect the involved components (Lakehouse table, Copy Data node) to work together regardless of the data type. I expect the Copy Data node to be able to convert whatever Fabric data source is used to whatever Copy Data target is used. It's both integrated and core functionality of Fabric. Converting a date field from a Lakehouse table into a JSON field (string, essentially) should be no rocket science (if in doubt about the target format, either use ISO date per default or offer a way to configure a desired format). I expect the Copy Data node to be able to do that as it converts any other data type.
I see the error as a bug and would like to report it as that.
Hi Hendrik1980 ,
The best course of action is to open a support ticket and have our support team take a closer look at it.
Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Hope this helps. Please let us know if you have any other queries.
Will do. Thank you for the link.
I hope you got some insights over your query. Please continue using Fabric Community on your further queries.