Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Is it possible to connect a dataset to two gateways and is there any downside?
Because my Gateway has previously failed, I am thinking of connecting the data to another gateway on a seperate laptop so that if one refresh fails because the gateway stopped, the second gateway can keep the daily refresh going.
Any problems with this arrangement?
And is it feasible to have two Gateways for the same Dataset?
Solved! Go to Solution.
Hi, @vincetaylor
According to your requirement, I think the gateway cluster of Power BI can perfectly meet your needs. You can add another gateway under your original gateway to create a cluster using your laptop.
Once you added the data source to this gateway cluster to be refreshed, the secondary gateway will take over the position of the primary gateway if the primary gateway is down. And you can also choose to let traffic be distributed evenly across gateways in a cluster if you turned on this option.
You can follow this document to add another gateway to create a cluster:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @vincetaylor
According to your requirement, I think the gateway cluster of Power BI can perfectly meet your needs. You can add another gateway under your original gateway to create a cluster using your laptop.
Once you added the data source to this gateway cluster to be refreshed, the secondary gateway will take over the position of the primary gateway if the primary gateway is down. And you can also choose to let traffic be distributed evenly across gateways in a cluster if you turned on this option.
You can follow this document to add another gateway to create a cluster:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @vincetaylor
This video could help you understand how it works
https://www.youtube.com/watch?v=sPFRLy6XL1s
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
The concept is called, Gateway Clusters.
In scenarios where primary gateway fails to refresh the dataset, Power BI will switch the refresh to the secondary gateway without stopping the ongoing dataset refresh. And as well, if you would like, you can enabled the load balance on the gateway cluster.
For more info, please refer to the following doc:
Install an on-premises data gateway | Microsoft Docs
Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Docs
Did I answer your questions? Give a thumbs up and accept this post as solution!
User | Count |
---|---|
23 | |
21 | |
11 | |
11 | |
10 |
User | Count |
---|---|
49 | |
31 | |
20 | |
18 | |
15 |