Connecting SSRS with snowflake as user viewing the report

As of now I am using the SSRS reports by connecting to my snowflake account by specifying the credentials or by using a shared connection.
But now we should be able to view the reports with respect to each user by using the user specific snowflake account.
So whenever a user logs in to the ssrs report, In the backed the queries should be fired from the current user snowflake account insted of using the shared connection or creds provided .
Basically I want to use the feature shown in the image

Need some help in setting the connection this way.