cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wilberttouw
Frequent Visitor

Power Query Error: Object reference not set to an instance of an object

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)

 

 

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

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:

Add Data to an entity in Common Data Service for Apps by using Power Query

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

 

Steps:

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.

 

 

 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,149)