I am trying to find a film which I saw more than 15 years ago. I'm (almost) sure it was European and the title was translated as something like 'The Young Wizard (or Magician)'. The film was about a young, pre-pubescent boy who discovered he had various telekinetic abilities; the usual troubles at school, a girl was involved.
Somewhere near the end the school psychologist explained that as the boy was getting closer to puberty, he was going to lose the abilities.
The end scene was how his best friend (or him?) performed some 'ordinary' magic tricks on a scene, the audience applauded and in a final 'magical' act the boy made confetti fall from the ceiling.
I'm quite positive that it was not a horror movie, but rather what we call 'family movie'.