Forum Discussion
Microsoft fabrics Copy Activity Copy on prem data to Delta table
I'm copying on-prem server data into lakehouse (Microsoft fabrics Delta table) sample table: Id | Name | Creation_Date | Update_Date | 1 | Pr1 |2025-01-...
Hakuna_matata
Resolver I
Resolver IHi c_avu ,
The error suggests that Creation_Date field might be treated as a string or a non-date type. Ensuring that the Creation_Date column is recognized as a datetime field in the source may help.
After which we may use this expression to test
@concat('/year=', formatDateTime(item().Creation_Date, 'yyyy'), '/month=', formatDateTime(item().Creation_Date, 'MM'), '/day=', formatDateTime(item().Creation_Date, 'dd'))
Hope it helps!
If this solved your problem, please accept it as a solution!!