Creating an expression for the connection string
How do I create an expression for the snowflake connection string? Since I need to pass the username dynamically as a parameter to the connection string based on the user logged into the SSRS server, I need to convert the connection string to an expression. I need some suggestions on how to convert the snowflake connection string to an expression.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.
