Pregnancy sex

I'm 27 weeks pregnant. I have absolutely no sex drive. When I do have relations with my SO I feel completely repulsed and can't wait until it's over. I feel so bad because I want to please him and we used to be very sexual people. When will this go away? I want to want it but I just dont! Ugh!