I am using Power Query in Data Integrator of Power Apps to connect an onpremise SQL database with the onpremise gateway to an manual created Enity in CDS. I saw that the Line no. field showed the wrong data (10.00 in stead of 10000). So i created a new field Line no.2 with a different data type Whole number instead of Floating Point Number. In the mapping i mapped the line No 2 field. when i run the project i get the following Error:
Load to Common Data Service failed. Details: ID: : Object reference not set to an instance of an object.. (Job ID: dde2860c-5a16-4ade-a316-79c2fb1d6fc5)
Would you please share a screenshot of the field mapping, specially for the two field you mentioned?
Just from the error message, it should be caused by the required fields is without mapping.
Adding a blog for your reference:
if i map the crfb3_LineNo (Floating Point Number) = Data.Line No_ then i get LOAD STATUS Completed, but the data is 10 instead of 10000 (culture info)
if i map the crfb3_LineNo2 (Whole Number) = Data.Line No_ then i got the error.
Thats the only change in the mapping that i made.
1) i created the cds entty
2) i created the data integration project from the on premise sql table to the cds entity from step 1
3) saw that the line no field showed 10 instead of 10000 (could not modify the field in the cds entity)
4) add an lineno2 field in the cds entity with different type (Whole number instead of Floating Point Number)
5) change the mapping in the data integration project.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.