Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Power BI Dataset using multiple gateways?

Hello,   I'm wondering how, or if, it's possible for a Power BI dataset to use data sources from 2 different gateways?   We have a client with 2 gateways - one is in their domain and connected to...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous Correct, currently all data sources in a particular report need to have the same datasources on a single gateway.

NAOS's avatar
NAOS
Advocate III
7 years ago

Hi Anonymous  !

Seems you may be able to answer my question. I have two data sources (two different on-premise sharepoint sites) and I have set up a gateway to these sources to schedule refresh (the same gateway).

 

I can use the gateway with reports querying data from each of these sources, but the gateway doesn't work if I try to use it on a dataset that queries both sharepoint sites.

 

Is this a limitation on how gateways work? Or is it a different problem?

 

Thanks,

amonico's avatar
amonico
Regular Visitor
1 year ago

When you set up a gateway, you have the option to choose a cluster. All gateway connections need to be on the same gateway cluster. In the screenshot above they are two separate clusters, one starting with Pow and the second starting with CU. Create a new connection for the source all on "Pow" or all on "CU". See yellow highight below