I'd like to add a feature into my report that enables end users to add comments. I'd like to add these comments to my SQL database and link them back to my report. I'm not using Power BI Report Server.
I already know how to do the second and third bullet. First one is a tricky for me.
Is this scenario even possible?
Take a look at the PowerApps visual:
Which should be able to meet your requirements.