Power BI Dataflow cant read small decimals or columns that are mostly 0

[Anonymous]

I have a csv files with 600+ rows. There is no problem reading into Power BI Desktop but when read into Power BI dataflow, I encountered the following issues:

1. Columns with mostly 0 are read as all 0 -> tried sorting but end up other columns will end up becoming zero.

2. decimal numbers that are very small are read as 0 (e.g. 0.00000184 is read as 0) -> in order to avoid small decimals that are read as 0, i have converted it into text but small decimal ends up being read as scientific format 12E05 and not able to convert back into numbers.

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Try to change a measure column to data type text (so you will see numbers like ##.##000000000).

Similar question:

Power BI dataset loses decimals when created from dataflow

Best Regards

Lucien