PQ doesn't recognize value '0,76' as decimal number

Anonymous — Thu, 19 Mar 2020 08:52:46 GMT

Greetings

I import a file containing all the invoices in my organisation spanning a certain period. When I convert the column containing the amounts to a decimal number, I receive a single error for a cell: it seems PQ refuses to convert the value '0,76' to a decimal number. This is the only amount in the column less than €1 (i.e., having a 0 before the comma). I also tried to convert the column to type 'currency' or 'whole number' but I keep receiving the error. When opening the .csv in Excel the number in the cell is correctly displayed and recognized as '0,76', so nothing funky going on there. This is the full error message I get from PQ when clicking on the 'error' hyperlink:

"DataFormat.Error: We couldn't convert to Number.
Details:
,76"

Anyone know how to fix this? Greetings.

Re: PQ doesn't recognize value '0,76' as decimal number

artemus — Thu, 19 Mar 2020 11:39:37 GMT

In the menu, go to options, then under current file choose regional settings. Pick a Eurpoean country (not UK). Then hit refresh preview in your query.

Re: PQ doesn't recognize value '0,76' as decimal number

Anonymous — Thu, 19 Mar 2020 12:00:08 GMT

Thank you so much!

topic PQ doesn't recognize value '0,76' as decimal number in Power Query

PQ doesn't recognize value '0,76' as decimal number

Re: PQ doesn't recognize value '0,76' as decimal number

Re: PQ doesn't recognize value '0,76' as decimal number