To be able to use a parameter value as servername in a SQL connection. Change the parameter value, and all datasets bound to that datasource using this parameter as target gets updated at once (using the same credentials).
2 Comments
- That is already possible via M: I have a parameter "dbEvironment" with values prod, acc, sandbox, and use it (Advanced Editor): let Source = Sql.Database("sql-" & dbEnvironment & ".database.windows.net", "main-sqldb-datamart-" & dbEnvironment), DIM_COMPANY= Source{[Schema=opco &"_Finance",Item="DIM_COMPANY"]}[Data] in DIM_COMPANY
- Status added:Needs Votes
