Forum Discussion
Solved
Remove 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
Use the drop down in Name and just filter out the null's by unchecking it.
If 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
If you filter it in Power Query, the query will be optimized to exclude those rows and not import them.
