I built a Power Query Source = sql.databases("SERVERNAME"). It returns all DBs on the server, and all DBs share an idential schema. I filter & expand to get the same table across all DBs, and see all...
I have a very similar setup and problem where the query includes more than one database on the same server, but only one database can be entered in the connection setup. Was a solution found?