This question already has an answer here:
Please help me identify a story. It involves a magicians apprentice who summons a rain of fish by dancing incorrectly while casting a spell. His master had a cold or something and could not use magic at the time. There was something about summoning or trying to summon butterflies too.
I read it in the 90s. It had other funny stuff in it, like a Robert Asprin story, but probably not by Asprin based on what I've read recently in the Myth series. Probably not Xanth series as the characters in Xanth all seem to have one and only one power. Pretty sure it was a novel or novella, not a novelette.