Forum Discussion
Fátima
Helper II
Helper IIProblem deleting empty rows when transforming data
Hi! I have a table with about 10000 registries. I want to remove the rows that has a column set to null. I have done "Remove Rows -> Remove Blank Rows" twice. The first time it did remove a few, but ...
- In Power Query, you apply a filter to the column so that it does not include nulls.
- Regardless of the column, you remove rows that are blank. Start menu. Remove Rows option, Remove Blank Rows option.
When you filter values out of a column in the query editor, it's essentially the same as deleting them. Those values will not be loaded to your data model, which will have the benefits of decreasing your load time and having fewer rows to process your calculations against.
JadhavVarsha_13
Helper V
Helper V- In Power Query, you apply a filter to the column so that it does not include nulls.
- Regardless of the column, you remove rows that are blank. Start menu. Remove Rows option, Remove Blank Rows option.
When you filter values out of a column in the query editor, it's essentially the same as deleting them. Those values will not be loaded to your data model, which will have the benefits of decreasing your load time and having fewer rows to process your calculations against.
FátimaHelper II
Helper IIThat worked perfectly! Thanks! 😁