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...
Thanks Anonymous for following up. My PBI desktop SQL datasource connects to the SQL server, without specifying a specific DB (I want to get the same table from 10+ idential DBs). However I cannot create a gateway connection without specifing a DB on the server (screenshot 2). If I do specify a DB during gateway connection setup, I cannot map my datasource to the connection (screenshot 1). What I really need is for the DB name on the gateway connection setup to be optional.