Forum Discussion
Solved
Filter values in column
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?
- 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
1 Reply
- 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