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
- fbcideas_migusrNew MemberStatus added:New
- mriedmuellAdvocate IIf 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.
- nickteffAdvocate I
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v19 hours agoCommunity ChampionNew618Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v1 day agoCommunity ChampionNew21Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401971 day agoFrequent VisitorNew6Views0likes0Comments