As I have written a reply to Bypassing / Excluding IP address from Pi-Hole not working - #6 by Bucking_Horn, I can confirm that a working solution can be achieved.
You have two options:
Option 1
Assign a static IP through Pi-hole's Admin panel and manipulate Pi-hole's own /etc/dnsmasq.d/04-pihole-static-dhcp.conf
in the way that 04-bypass.conf
suggests, but without creating a separate file.
This is the variant I tried myself, and it comes with all the caveats I've described in my older reply (especially manglig the UI), so you want to re-read that.
Option 2
Leave Pi-hole's Admin panel alone - if you have already defined static IPs before, this might involve releasing and removing each static IP device that you want to bypass Pi-hole.
Then supply a slightly altered 04-bypass.conf
that complies with the following structure:
# use Google DNS
dhcp-option=tag:googledns,6,8.8.8.8
# devices to use Google DNS
dhcp-host=MA:CA:DD:R:ES:SS,set:googledns,192.168.x.x.,machine-name
This might circumvent some of the problems with Option1, but I haven't tried it.
Let us know which option worked for you