Let’s Consolidate…

Okay- so you’ve got one, maybe more, SQL servers with many DBs, what’s an analyst to do?

One way to do it is to have a ‘source’ for each Server/DB combination. This method will not scale well and is VERY time consuming. One change in the query can translate to 20+ mins of copy and pasting the query over and over. This also means you’ll have to add a connection to your Gateway for each DataBase/Server combo.

In our scenario the list of DB’s we want to consolidate and run the query against is always changing, so constantly editing the gateway is unrealistic. I also know that the query is changing everyday during development, and I really don’t want to spend time copying and pasting a query dozens of times a day.

PowerQuery Functions are exactly what we need.