Itegnodr007 Can't convert field 'reversal_transaction_id' to type 'decimal?'

[sve55]

The following error occurs on downloading data from Chargebee into Power BI:

itgenodr007
Can’t convert field ‘reversal_transaction_id’ to type ‘decimal?’.
The value ‘txn_198aIAUOXHRtzUl’ is not a valid decimal.
The input string ‘txn_198aIAUOXHRtzUl’ was not in a correct format.
Use decimal dot ‘.’ as a decimal separator and comma ‘,’ as a thousands separator.

[forums]

The actual payload of reversal_transaction_id seems to contain non-decimal values now also.

A change will be included in the next release of Invantive Cloud to change the data type from decimal to text.

Please consult Release frequency Invantive Cloud for the expected availability.

[forums]

In release 24.0.310 the data type was changed from decimal to text. The new release has been taken into production on Invantive Cloud.

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.