I have been at an interview where there were THREE no-shows that day. No call, no nothing! The secretary was so irritated, even though she tried to hide it. Also been at one with 1 no-show.
I would think that cancelling even with a days notice is better than showing up and wasting their time and money. No-shows are shameful though.
The more advanced notice the better!