Large data file with decimal value error

[im-saboor]

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!

[Zanqueta · Accepted solution]

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 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.

[v-csrikanth · Accepted solution]

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 · Accepted solution]

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 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.

[im-saboor]

Thank you so much, it works like a magic 🙂 Number.From([ColumnName]) otherwise null