Forum Discussion
Power Bi not reading decimal values in data
The data source is an excel sheet which has a column say "col1" with values {0.1, 0, 0.11, 0.25}. When I read this sheet into power BI by using advance editor, the column contain value {0,0,0,0}. Even if I change the type to decimal, the column appears as {0.00, 0.00, 0.00, 0.00}. Request help on reading the input.
8 Replies
- amitchandak
Super User
GO to Edit Query/Data Transformation mode and change data type there and reload if needed.
- Geradav
Responsive Resident
Hi Anonymous ,
Seems weird indeed.
Would you have some screenshots about the steps to provide more insights on the matter?
Also, I am thinking about regional settings. Have you set up your regional environment correctly?
Just a broad guess.
Let us know
Best
David
Syndicate_AdminAdministrator
Hello!
My case was exactly the same, try to modify from excel and nothing, then on the BI format options and nothing, hsta that modify from power querry and manage to visualize the decimals.
