topic Re: Pipeline change Date to Datetime in Pipelines

Pipeline change Date to Datetime

HarderT — Tue, 07 May 2024 14:48:32 GMT

Hi together,

this is an example of my Importjob. I create a Table with a lot of tablenames from our source database and the ForEach-Task copy the table into our Lakehouse.

In the process, become .

Does anyone have the same problem and know a solution?

Re: Pipeline change Date to Datetime

Anonymous — Tue, 07 May 2024 15:31:44 GMT

Hi HarderT

Thanks for using Fabric Community.

Are you using On prem database here?

Have you set/checked the data type in the Mapping tab in Copy?

Re: Pipeline change Date to Datetime

Anonymous — Tue, 07 May 2024 17:58:51 GMT

Hi HarderT
Under mapping you have Advanced settings:

If in the source, the column is determined to be a String then running the type checker doesn't understand the source's format.
If you need to force a String -> Date, precreate the table.

Hope this helps. Please let me know if you have any further questions.

Re: Pipeline change Date to Datetime

HarderT — Wed, 08 May 2024 05:53:23 GMT

Hi Anonymous,

the source is an OnPrem-Database. The Columntyp there is DATE and after import into Lakehouse its DATETIME.

I dont use the Mapping-Tab, because I use a ForEach-Loop to import many tables.

I already tried to change the typ with Type conversion settings, but somehow it doenst work. I need the column not as string, but as same as in the source.

I try to precreate the table and see what happens.

Re: Pipeline change Date to Datetime

HarderT — Wed, 08 May 2024 08:51:34 GMT

I have seen that there is already a known issue for this. However, I use Pipeline and not Dataflow Gen2.

Known issue - Type mismatch when writing decimals and dates to lakehouse using a dataflow - Microsoft Fabric | Microsoft Learn

Re: Pipeline change Date to Datetime

Anonymous — Wed, 08 May 2024 09:26:59 GMT

Thanks for the details HarderT
I will keep you posted regarding the updates of this known issue. Appreciate your patience.