Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am importing a CSV file to Power BI. Data in one particular column is not being pulled accurately.
Original:
First Column: The data consists of Nulls, 0's and decimal data.
But when imported to Power BI, only 0's and null's are being pulled. The decimal values are replased by "0".
There are no filters applied and nothing has been edited in power query. I also tried copying and pasting all data just as values, dint work out. Tried just coping the column to a seperate sheet, dint work out either.
Any thoughts on why this anomoly would occur and how to fix it?
Thanks
Solved! Go to Solution.
What is the data type of the first column? If you change it to Decimal Number, are your original values retained? I'm not 100% but I think that the default data type chosen upon import has to do with the first row's values (based solely on my own experience) which may explain the difference between the three?
What is the data type of the first column? If you change it to Decimal Number, are your original values retained? I'm not 100% but I think that the default data type chosen upon import has to do with the first row's values (based solely on my own experience) which may explain the difference between the three?
@BekahLoSurdo , When I looked it up the default data type was "Whole Number" which explains the filtering of decimal values.
When changed to decimal, everything fell in place.
Thanks for your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |