Dynamic Application Name in OLEDB/ODC Connection String

I have several (more than 100) Excel reports (files) that use the same data connection file. The data connection file connects to SSAS 2012 Tabular Model.

From the SQL Profile data, I would like to know the name of the Excel report file the connection is coming from. I was hoping to use the Application Name property of the connection string.

However, looks like Application Name property accepts only constants / fixed text. Is there a way to pass Application Name dynamically? I tried using &[File] - like we use in Headers and Footers in Excel. But the profile data just logs "&[File]" in the Application Name column. Any easier way to capture file name/path.

I do not want to use VBA. That would require modifying all Excel copies. I am hoping to make a change in the data connection file (within the connection string) so all Excel files would log dynamic Application Names automatically.

Thanks in advance for your help.

0 answers