cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Enileda3
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Enileda3 ,

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

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @Enileda3 ,

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
Community Support
Community Support

Hi @Enileda3 ,

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

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.