Filter values in column

[Recoba88]

Hi,

1.If I filter blank rows or rows with null is this equal to deleting them?

2. When I referesh power query the blanks rows refreshed too ? If they filtered?

[MFelix · Accepted solution]

Hi @Recoba88,

In the query view in PBI if you filter out the blank rows that is the same as deleting them since the data that os transfer for the PBI model will not include thwm. When you refresh your model they will be excluded out since you can compare the query model to a macro and every time it's tun it will filter blanks out.

Regards,
MFelix