Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
If you filter it in Power Query, the query will be optimized to exclude those rows and not import them.
Use the drop down in Name and just filter out the null's by unchecking it.
Cross posted: https://social.technet.microsoft.com/Forums/en-US/2d68a4e4-f4d6-4280-b7d1-5630703008c2/remove-rows-i...
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |