Forum Discussion
DataFormat.Error: Invalid cell value '#N/A'.
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
Hi Kopek ,
You could right click the column which including errors and select the option Replace Errors.
Best Regards,
Cherry
Hi Cherry,
I tried that option for entire table, and in query it looked fine, but when i clik save & apply button, i had Data Format Error.
Maybe because there is too many rows (few thousand) ?
Hi Kopek ,
Please check if you have installed the latest version of Power BI Desktop 2.66.5376.2161.
In additiom, if it is convenient, could you please share the data sample which could reproduce your issue so that I could have a test in my site.
Best Regards,
Cherry
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
