I have played a few places where there was no dancing. A Sunday Brunch at a seafood restaurant, Ralph and Kackoo's, an art show I play every October (BORING), political fundraiser dinners (they would have to dance on the tables, but that would probably be all right at $200. a plate!), a couple of funerals, a wedding (not the reception).
I sometimes play for special occasions in the dining room, rather than the lounge, at my "regular" job. There is no place to dance in there, but sometimes a couple will get up and dance anyway!
However, I still do pretty much the same music anyway.