Has anyone successfully used Power Automate to dynamically pull SSRS reports using report parameters from the SQL Data and email them off when a new SQL row is created?
I am looking to do this and would be interested in seeing what others have done.
Thanks!