Forum Discussion
Kopek
Helper IV
7 years agoDataFormat.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, ...
- 7 years ago
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
leandroab1
Advocate II
3 years agoTransform > Replace Errors. It will clean the #N/A.