cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
josegdiazv
Regular Visitor

Error while importing data in CDS with Dataflow

Dear support,

 

I am getting error while trying to use a Dataflow to import data in CDS from an Azure SQL DB:

 

{"error":{"code":"0x0","message":"An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal '191.00' to the expected type 'Edm.Int32'. ---> System.FormatException: Input string was not in a correct format

 

Any suggestion what it maybe happening?

 

Thank you in advance,

 

Jose G Diaz

4 REPLIES 4
sperry1625
Solution Supplier
Solution Supplier

Integers are whole numbers, no decimal positions. If you want 191.00 the destination field needs to be Currency or Decimal Number type.

 

Please mark as solution if this solves your problem.

 

Thank you.

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thank you for the reply Sperry1625, the destination fields are decimal, actually all is being pre-populate from the dataflow creation (import in new DB) itself nothing changed.

 

josegdiazv_0-1641308968456.png

josegdiazv_1-1641309004614.png

 

Thank you in advance,

 

Jose G Diaz

 

 

 

 

The field you have highlighted above, Segment Distance, is defined as a Whole Number not a Decimal Number. Is that the field you are referring to? Is that the field that is generating the error? What is the source field defined as?

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

rampprakash
Super User
Super User

Hello @josegdiazv

 

Change the Value '191.00' to '191' and try.

 

Because system expecting IntegerNumber(whole number) but the value which you are passing is Decimal

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

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.

Users online (3,045)