Forum Discussion
Recoba88
Helper III
Helper IIIRemove rows in Power Query
Hi,
If I want to remove rows (3,4,5) - all the rows automatically that have no value (null) in specific column (name)
How can I do it?
The reason that I don't want that my excel workbook will bring data that I will not use and will calculate it when file will be refreshed
If you filter it in Power Query, the query will be optimized to exclude those rows and not import them.
4 Replies
- Greg_Deckler
Community Champion
Use the drop down in Name and just filter out the null's by unchecking it.
Recoba88If I filter the data like you said
I still don't want that my excel workbook will bring data that I will not use and will calculate it when file will be refreshed
- Greg_Deckler
If you filter it in Power Query, the query will be optimized to exclude those rows and not import them.
