I am trying to upload data that has blank cells in a column. It shows that the row have errors.
I tried using "isblank" option and I get the error IF not recognized.
Is there anyway to upload the data without any errors?
Go to Solution.
One workaround is to replace the error with "null",
Then "Close&&Apply", in the Data view, "null" shows as blank
There is a similar thread, it seems like your case, could you check the final reply to see if it helps you?
"I tried using "isblank" option and I get the error IF not recognized."
Do you mean you use DAX function "ISBLANK" and "IF" function?
If only the blank cells show errors, other cells are correct, you could go to Queries Editor->Replace Errors(Replace error with blank)
Reference: Power BI Pro Tip: Dealing with errors when reading Excel files
If you are not in the scenario above, please let me know more details, a scennshot or an example table (with columns show error in power bi) is prefered for analysis.
Thanks for the response.
When I right click and select "replace error", it asks for a value. and when I keep it blank. It doesn't accpet it.
Is there any other navigation option that can do this operation to replace errors with blank?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.