PowerBI Gateway -Single data source to multiple Dbs within a single SQL instance doable?

[NMAN47]

I had been adding data source connections within the PowerBI gateway clusters to various on-Premise SQL server databases. Recently I received a request to add connections to about 40 databases within a single SQL instance. Is there a recommended way of adding or providing access to numerous databases within a single instance with out having to create 40 separate data source connections?

Thank in advance,

Nimesh

[v-shex-msft · Accepted solution]

Hi @NMAN47,

Unfortunately, gateway data sources not based on instance. Even if your source data are from same sql instance, you still need to configure datasources for each tables.

Regards,

Xiaoxin Sheng