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
