Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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