Forum Discussion
Solved
sql.database , Can't save dataflow One or more tables references a dynamic data source.
I cannot find a way around this and need some guidance. Below is the function I am calling from my queries. The problem I am having is that i need someway to grab the host_id_address in the srcDeale...
You cannot dynamically swap the connection in a Sql.Database() source (or in any other source for that matter)
BUT. If your databases all reside on the same server AND you have access to all the databases you can cheat by specifying a fixed database name in the connection and then override it in the query.
Unfortunately there's about more than 100 differnt ips. The workspace would separate them out, so I was hoping the function above would resolve the issue for us having to hard code each data flow into the workspace the data connection as some will have more than one in which case we'll have to udpate teh flow for those group. And potentially more will go online.
If this is the limitation then there's nothing we can do about it.