Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
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
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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
20 | |
19 | |
16 | |
13 |
User | Count |
---|---|
42 | |
24 | |
23 | |
18 | |
12 |