ODBC driver problem
After changing the Microsoft Access Engine odbc driver from version 14 to version 16, I cannot connect to the excel file. I have a connection as follows: Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path.xlsx;ReadOnly=1;HDR=No; error with this is: ERROR [08004] [Microsoft][ODBC Excel Driver] Too many client tasks When switching to the OLE DB driver I get the error: Unspecified error On the Microsoft Access Engine version everything works fine. SSRS: Version 13.0.7050.2
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.
