Parameterizing data connection

[GeraldBritton]

Trying to parameterize connection as per https://support.microsoft.com/en-us/office/customize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd728...

However, Parameters button is greyed out. What do I do?

[#2]

@GeraldBritton 

Can you share more information on your project - if possible, a workbook without confidential data.

Also, are you using PowerQuery to set up the connection?

[#3]

@adversi I attached a workbook.  Take the first sheet as an example.  I want to parameterize the server name in the connection string.  I attached a screenshot of what I want to parameterize and the workbook 

[#4]

@GeraldBritton 

Sorry, not entirely sure what the right solution would be. I did find that CRSIRVBC01TBV,3341 SSISDB connection is doesn't have its connection file grayed out.

Maybe these two articles can help:

Dynamically assign filename to excel connection string 

Passing Dynamic Query Values from Excel to SQL Server 

[#5]

@adversi Thanks for taking a look.  I did read the linked articles, which can help if you want to parameterize the query.  However I want to parameterize the connection instead, which doesn't seem to be covered.