Suggestions for selling a rental property with a tenant?

I might want to sell a rental property I’ve got. The current tenant has about a year left on the lease.

This is problematic because potential buyers who want to live in the house themselves would, of course, want to walk through. My tenant doesn’t really have any incentive to assist with this process and might not want to participate, making showings difficult.

Or we could limit prospective buyers to only those who would keep it as an investment property… to continue renting it out. But the conventional wisdom there is that those kinds of buyers only want to buy a great deal, driving the price down.

Have you sold an occupied rental property before? How did you overcome these challenges? What others came up?