[DataFormat.Error] Invalid cell value '#N/A'

Hello gurus,

apologies if this has already been responded but i could not find any reference in the Community. 

I had the following error thrown today [DataFormat.Error] Invalid cell value '#N/A' which thwarted the refresh of our report in the PBI Service.

Basically i was importing a csv file with #N/A values on three columns.  In the Data steps (Edit Query) I had already some Replace.Value() function for those columns both for #N/A and for n/a in order to replace 000, but still the error was thrown. 

I have then finally add a further step Replace.Error() on the three columns and everything was refreshed perfectly.

Do you know why this? Is Replace.Error() better for this type of error than Replace.Values().

Another point: the csv file was relatively old ( imported since 2 weeks) and the refresh was OK until today. Do you know why this? There has been any update to the PBI Service? 

Thanks in advance

Luca