Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tamiribas
Resolver I
Resolver I

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, in the settings of the dataset, I get an error trying to connect to the 3 of them.

Why do I get 3 different screens for a connection?

 

Any help would be appreciated ,

Thank you

Tamir

 

 

GWs in Genie.png

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

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 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
GilbertQ
Super User
Super User

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 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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!

 

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.