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.
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.