Forum Discussion
Solved
DataFormat.Error: Invalid cell value '#N/A'.
I connceted whole folder to the PBI, and I am receiveing the above error. Each month new excel file will be added to the folder. The #N/A value is in different columns - not always in the same, ...
Hi Kopek ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Transform > Replace Errors. It will clean the #N/A.