Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

PowerBI / CDM / Datalake Gen 2

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

 

Status: Accepted

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Accepted

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