Power Query Automatically Filtering Out Null Values

[newpbiuser01]

Hello,

I am running into an issue while filtering out specific values from a column in Power Query. After I filter out the said specific values, and create my reports, if a Null value is added in that filtered column, that row gets filtered out as well. 

As an example, if I have the following data and I filter out the Name column to exclude "DEF":

Name	Count	Year
DEF	50	2023
HIJ	78	2022
ABC	45	2020
GHI	10	2024

Table.SelectRows(#"Changed Type", each ([Name] <> "DEF"))

I get the following result when I try to visual in Power BI:

Now, if I update my data to include a null value in the Name column, refresh the data, and still have "DEF" filtered out from my name column, I see the null row in the Power Query, however, when I push close and apply in Power Query, the null row gets filtered out automatically. 

Would anyone know why the row where the Name = null get filtered out even though I have clearly defined the filter to exclude just the value "DEF" from the Name column :

Table.SelectRows(#"Changed Type", each ([Name] <> "DEF"))

I'd appreciate any insight on why this is happening and why nulls are treated differently. 

Thank you!

[ray_aramburo]

Check on the data view if the value is there as a null or as a blank. If it exists there, then the issue is on the visual and you might need to do some steps to show blank values.