PowerBI / CDM / Datalake Gen 2

[Anonymous]

Hi,

We have data being published from D365 F&O to Data Lake.

We connect to the Data Lake using CDM :

https://xxxxx.dfs.core.windows.net/dynamics365-financeandoperations

The data pulls through in the correct structure, with the correct tables.

However many of the dates come through as 'error', I cannot transform these as when the data is parsed it errors before the point we can do a transformation, i.e. if i convert the column to text at the earliest opportunity it still shows the date error.

Error in PowerQuery : 

"DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
2022-05-16T00:00:00.0000000"

It appears to be a bug in either the generated CDM, or the parsing of the JSON file that provides metadata.

JSON states : 

{
" ""name"": ""ConfirmedDeliveryDate"","
" ""appliedTraits"": ["
" ""is.dataFormat.date"","
" ""means.measurement.date"""
],
" ""attributeContext"": ""ConsignmentReplenishmentOrderHeader/attributeContext/ConsignmentReplenishmentOrderHeader/ConfirmedDeliveryDate"","
" ""isNullable"": true,"
" ""dataFormat"": ""Date"","
" ""displayName"": ""Confirmed delivery date"""
},

Data is in this format, as above : 2022-05-16T00:00:00.0000000

Thanks

Andrew

[v-xiaoyan-msft]

Hi @Anonymous ,

We have reproduced your issue and have submitted to internal icm 313127557, engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

Best Regards,
Community Support Team _ Caitlyn