Forum Discussion

tamiribas's avatar
tamiribas
Resolver I
3 years ago
Solved

Issues with multiple gateways

Hi I have 3 sources connected to the PBI file. Each one of them is on a different server and there is a gateway on each one of them. The gateways are online as so are the data sources. However, i...
Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    Hi tamiribas 

     

    Currently all data sources need to go through a single gateway. 

     

    Unfortunately what you are trying to do today is not possible. You need to have them all configured in one gateway.

    You can vote for the idea https://ideas.powerbi.com 

GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi tamiribas 

 

Currently all data sources need to go through a single gateway. 

 

Unfortunately what you are trying to do today is not possible. You need to have them all configured in one gateway.

You can vote for the idea https://ideas.powerbi.com 

  • Hid's avatar
    Hid
    Regular Visitor
    2 years ago

    Hi,

     

    I am having exactly the same problem.

    2 SQL Servers on the same network. I've put a gateway on both servers.

     

    Any PBI report that has data from ONE Server, I can publish, point it at the right gateway/connection and it's all good - I can do scheduled refreshes.

     

    However, if I create a report using data from both servers and I publish it, I can't point the datasources to the right gateway/connection. Well, I can but it won't let me appy it.

     

    The answer above says that all data sources need to go through a single gateway.

     

    I'm nearly certain a lot of people use PBI to bring data from mutiple sources and they need to do scheduled refreshes.

     

    Could someone point me to how you can set up a single gateway on one of the servers and access the other server through it please.

     

    Thanks!