Forum Discussion
Solved
Large data file with decimal value error
I have large number of columns consist of volumes and text along with dates. Any quick solution to solve this decimal error. Thank you for your help!
Hi im-saboor
A simple approach is to identify the problematic column and assign the correct data type, or use a safer conversion with try ... otherwise so that a single invalid value does not cause the entire query to fail.try Number.From([ColumnName]) otherwise nullFor large datasets, I would also check whether some columns containing identifiers, invoice numbers, barcodes, or account numbers should be stored as Text rather than Decimal Number.Hi im-saboor
We would like to inquire whether have you got the chance to check the solutions provided by Zanqueta in community to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Zanqueta
Super User
Super UserHi im-saboor
A simple approach is to identify the problematic column and assign the correct data type, or use a safer conversion with try ... otherwise so that a single invalid value does not cause the entire query to fail.
try Number.From([ColumnName]) otherwise null
For large datasets, I would also check whether some columns containing identifiers, invoice numbers, barcodes, or account numbers should be stored as Text rather than Decimal Number.
Thank you so much, it works like a magic 🙂 Number.From([ColumnName]) otherwise null