I want to be able to dynamically change the connection string for a copy activity based on an environment variable (ex: DEV, QA, PROD).
Instead of using the drop-down for connection in the copy data activity, I'm looking to parametrize it.
The issue occurs after I create that dynamic connection string, I'm unable to select the connection type of SQL Server. I only get the options of Lakehouse, KQL Database or Warehouse.
3 Comments
- Status added:New
- If you follow the best practises advice for rollouts in Fabric through workspaces synced with Git, dynamically adjustable connections are mandatory. No one wants to adjust each and every connection after syncing features into a DEV workspace.
