Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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