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

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.

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.

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.

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.

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.