Skip to main content

Power BI

New

Add Keep Empty in Power Query editor

Vote (1) Share
Christian Villegas's profile image

Christian Villegas on 16 Jul 2021 15:28:57

In the Power Query editor the Remove Empty is extremely helpful; however, when troubleshooting a Keep Empty would be extremely helpful as well to find the empty rows that might be present in a column. Instead of just removing them this might provide insight into what you can replace those values with. 



I know that there are workarounds by using the Column Profile and / or create a filter on null, but this simple step can save a few minutes each time if you have any data that might be disorganized upstream.