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

[zanottiluca]

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

[v-jiascu-msft]

Hi Luca,

Can you share a little sample? The data like below doesn't have issue.

col1        col2          col3

a	100	jack
#N/A	200	power
b	#N/A	bi
c	300	#N/A

Best Regards,

Dale