Whether the CF card works without power connected to the adapter or not, is not a property of the adapter. It is a property of the CF card. Certain cards don't require the power cable to be connected, and some do.
I have CF cards of both kinds.. A 256MB that works without connecting power to the adapter, and a 4Gb card that doesn't work unless you connect the power cable. The adapter has nothing to do with it. You can try several cards to know which ones require power vs ones that work without the cable.
Turbo XT 12MHz, 8-bit VGA, Dual 360K drives
Intel 386 DX-33, Speedstar 24X, SB 1.5, 1x CD
Intel 486 DX2-66, CL5428 VLB, SBPro 2, 2x CD
Intel Pentium 90, Matrox Millenium 2, SB16, 4x CD
HP Z400, Xeon 3.46GHz, YMF-744, Voodoo3, RTX2080Ti