Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
Thank you so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.