How to connect 8 different Onpremise MSSQL Servers all together in order to build Powerbi reports?

[Anmolgan]

Hi I am looking for a way to connect 8 different On premise sql servers that are hosting databases all together, I want to connect all opf them together and build an interactive powerbi reports. Are there any ways in which I can do this, I read about the powerbi data gateway, but its not for multiple locations if I am correct, can anyone tell me how can this be done?

[v-chuncz-msft]

@Anmolgan,

You may try to make use of OPENROWSET.

[Anmolgan]

Hi,

Can you tell me more about this command?

Is there any other method whiCh I CAn use to get the data?

[Anmolgan]

I have 5 different On-Premise SQL Servers, I need to connect with all of them in order to build a single report that involves comparisons, how can I achive this?

Can this be possible.