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...
Hi Samson217
You mentioned "I'm forced to select a single DB on the server, and I cannot map the connection between my data source" , can you explain it in detail ? From the first screenshot , the second data source corresponds to having an add to gateway , you can add the corresponding data source through this .
Best Regards,
Community Support Team _ Ailsa Tao