Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data showing blank and null

Dears,   I've got a strange thing. The data input is MySQL database. The Part Number column contains "Blank" and the ons look blank.  The "Blank" is really null, so IsBlank() returns "True". Howev...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, v-lili6-msft 

 

The (Blank) and (Null) cells are both in edit Query and Power BI  data view, we can see two of them.  And moreover, there's only 1 table in this Power BI file.
  

 

 

However, space character can be calculated by Len(), as following screenshot. But the Len((blank) cells) returns 0. What's can be space characters?

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi Anonymous 

Could you please share your sample pbix file for us have a test.

 

Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, v-lili6-msft 

     

    This's from database, it's not allowed to send out of the company. However, when I copy the data into Excel, all the (Blank) and (null) cells turn out to be (null), it's confusing. I can only keep them now.