Forum Discussion
DataFormat.Error: Invalid cell value '#N/A'.
Are you using excel as datasource? Sometime in excel in formulas you have value "#N/A" and that could be the root cause for this. You need to replace that value using query editor with "null" or space and I guess that will do it.
Power Query in Power BI and Excel simply does not support values that represent errors such as: "# N / A", "# N / A"
I lost a lot of time, everything to find that you have to look for them manually in the table, in my case in the excel source, it is useless sometimes to filter and try to detect these values in the search list, I had to check the entire column to search and delete them.
Power Query en Power BI y Excel simplemente no soporta los valores que representan error tales como: "#N/D", "#N/A"
He perdido mucho tiempo, todo para encontrar que hay que buscarlos manualmente en la tabla, en mi caso en la fuente excel, es inútil a veces filtrar e intentar detectar estos valores en el listado de valores, yo tuve que revisar toda la columna para encontrarlos y borrarlos.
Hope it works for you. Hope MS could care soon.