Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting rid of NeuN value

I have a database coming from a .csv file. However, I am getting some cell values with "NeuN" after loading the csv file into Power Bi. These cells in original csv file have next value " NaN".   To...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous Testing different things you suggest, leads me to the original csv. I added a new row and saved it again. Now, when loading into Power Bi, there is no problem at all to get rid off the NaN values. I can use "replace values" and It recognizes them perfectly. I presume there must be an error in the way csv file is built from original source. Thanks for your help!

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous Testing different things you suggest, leads me to the original csv. I added a new row and saved it again. Now, when loading into Power Bi, there is no problem at all to get rid off the NaN values. I can use "replace values" and It recognizes them perfectly. I presume there must be an error in the way csv file is built from original source. Thanks for your help!

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Glad i could help 😛

Please consider marking your reaction as a solution as i can be helpfull for others 🙂

Happy building! 😄