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
Go to Solution.
If you filter it in Power Query, the query will be optimized to exclude those rows and not import them.
Proud to be a Super User!
View solution in original post
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
Cross posted: https://social.technet.microsoft.com/Forums/en-US/2d68a4e4-f4d6-4280-b7d1-5630703008c2/remove-rows-i...
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.