Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.