Error while importing data in CDS with Dataflow

(0) Share

Report

Posted on by Jose Gregorio Diaz

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

sperry1625 763 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jose Gregorio Diaz 67 on at

Like (0)

Report
Copy link

Link copied!

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.

Thank you in advance,

Jose G Diaz

Was this reply helpful? Yes No
sperry1625 763 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,660 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No