How to execute the same SQL Script on various Servers in one Execution

[Anonymous]

Hello,

I would like if it possible to combine the execution of the same SQL Script but on three different servers and to get one table?

So imagine that I have Server A, Server B and Server C and the Script1.

What I would like to do it is to execute in one time the following steps and get one combine table

connect to Server A

Execute Script1

Disconnect from Server A if necessary

connect to Server B

Execute Script1

Disconnect from Server B if necessary

connect to Server C

Execute Script1

Then get one combine table.

Up to now, I am able to run each separatly by I need to combine the table after.

So I wonder if there is a way to carry out that SQL Task in power bi in one time.

Regards,

[kentyler · Accepted solution]

You can probably use Power Automate https://flow.microsoft.com/en-us/connectors/shared_sql/sql-server/