cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vincetaylor
Frequent Visitor

Setting up two gateways for data refresh

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?

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

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.

v-robertq-msft_0-1618823783349.png

 

You can follow this document to add another gateway to create a cluster:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#add-another-gatewa...

v-robertq-msft_1-1618823783352.png

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.

View solution in original post

3 REPLIES 3
v-robertq-msft
Community Support
Community Support

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.

v-robertq-msft_0-1618823783349.png

 

You can follow this document to add another gateway to create a cluster:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#add-another-gatewa...

v-robertq-msft_1-1618823783352.png

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.

View solution in original post

aj1973
Community Champion
Community Champion

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

_sfrost
Solution Specialist
Solution Specialist

@vincetaylor 

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!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!