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
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