Power Query can't read data type from the CDM manifest.

[AlexMunday]

Hello,

I wrote some manifest where I wrote the data type of the column.

for exemple:

{
"name": "Sys_OriginCode",
"dataType": "integer"
},
{
"name": "Sys_LoadBy",
"dataType": "string"
},

but when I load the CDM folder with Power Query the data type is not recognize.

Is that normal or did I missed a step?

Best

[Syndicate_Admin]

Great to see the DM folder in DataVerse and the Model actually starts being manifested in production. I was hoping all the involved partners in the creation of the CDM for the majority of generic business process and operational activities would create a perfect standard. 

I just receveid a nice email and saw your post the combination with the technical point of view of limitations made me laugh. "You'll soon run out of Database capacity" I also saw your post and thought the CDM integration update must be completed. And for sure do not think the Database capacity as mentioned in the notification has anything to do with the technical capabilities.

Maybe upon reading the notification this would be very nice to mention its not a technical limitation.

The size of CDM a well orchastreted comprimize.

[AlexMunday]

Hi,

Thanks a lot for the help I change it from dataType to dataFomat and put the correct data format and it worked 🙂 

How come in https://github.com/MicrosoftDocs/common-data-model-and-service/blob/master/common-data-model/creatin... they used dataType and not dataFormat?

best,

Alex

[v-eqin-msft · Accepted solution]

Hi @AlexMunday ,

Please try to replace integer with int64.

Refer to :

https://blog.crossjoin.co.uk/2019/03/13/attaching-manually-created-common-data-model-folders-in-powe...

https://docs.microsoft.com/en-us/common-data-model/sdk/trait-concepts-and-use-cases

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.