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 make sure about the error, I edit the query and obtain a new column based on try expression. However, "HasError" is always False. Is there any way of getting rid of "NewN" values? Is it possible to replace them for null or empty ones? Thanks in advance!

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!

Getting rid of NeuN value | Microsoft Fabric Community

Forum Discussion

Related content

Getting Period values from Cumulative

Getting value for previous year based on value name and year slicer

Deshacerse del valor de NeuN

DAX getting previous value

Get Second highest value