Service | Customer Service, Contact Center, Fie...

Powerapps export to datalake, Azure data factory ingestion

(0) Share

Report

Posted on by Scosec

Hi Guys,

I'm not sure i'm targetting the right forum for my question. Since this involves dynamics CE data export i'll try here.
There might be an overlap with Azure data factory

Using the following docs i have created a export to our datalake:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/export-to-data-lake

The export is working quiet perfect. Our data lake contains a export with the common data model (CDM). and it's data files.
Using the mapping data flow in Azure Data Factory i'm reading the common data model. Which works for all fields except date columns.

All dates appear to be blank/null when previewing or processing the data with ADF (mapping data flows).It appears there is a misunderstanding between (my guess) the date format.
The export has date fields in following format: 2020-11-03 09:25 AM. I'm thinking that the common data model expects it as the following format: 2020-11-03 09:25:00

Are there more people experiencing similar issues?

Thanks in advance.

Ivo

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

Hi Scosec,

The default datetime field format is 12 hrs, what you need is 24 hrs.

1.You can go top corner gear icon > Personalization Settings.

2.Go to Formats tab and click Customize button.

3.Go to Time tab and select H:mm in time format, then click Apply and Ok button.

4.Refresh page, you will find datetime field value is 24 hrs format.

Also. You notice that time format is 17:30 not 17.30.00, which is because D365 do not support show seconds in datetime field, this is by-design.

Was this reply helpful? Yes No
Scosec 95 on at

Like (0)

Report

Hi,

Thanks for your reply. This involves the GUI and is not where the issue lies.

ADF product team is currently investigating.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Scosec

OK! Hope your problem will be resolved.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
kb8787 5 on at

Like (0)

Report

Did you ever find a resolution for this from the ADF product team?

Was this reply helpful? Yes No
Suggested answer

Scosec 95 on at

Like (0)

Report

Hi,

Yes, they responded with the following images. You can set additional (accepted) datetime formats as following:

Was this reply helpful? Yes No