can drill tiles using normal drill mode. not rotary drilling mode

For 'soft' ceramic tiles, which is the typical tiles for typical bathroom, you can use SDS+ masonry bit with DRILL ONLY mode. Use masking tape to prevent dill bit from wondering or slipping. Start slowly and push a bit. 

For porcelain or HARD ceramic tiles, get a DIAMOND core dill bits. Most of these drill bits are not SDS+, so, use normal impact driver or use chuck adapter. Refer to our discussions on page 2 of this thread.