How to upload blank cell on Power BI Desktop without any errors?

[Anonymous]

Hi Team 

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?

Thank You

Tahemin Afsha

[v-juanli-msft]

Hi @Anonymous

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

Best Regards

Maggie

[Anonymous]

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?

Thank You

[v-juanli-msft · Accepted solution]

Hi @Anonymous

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?

https://community.powerbi.com/t5/Desktop/How-to-Remove-Error-in-Date-Field/td-p/347460/page/2

Best Regards

Maggie