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.