Data Gateway Architecture

[Anonymous]

We are currently in the process of getting Power BI off the ground and utilzing an Enterprise Gateway.

We currently have around 20 data sources mapped to the Gateway varying from Excel files in network drives, 4 - 5 SQL Servers (Both Direct Query and Import). 

We are starting to get more requests from business users that are starting to use Power BI and need connection to On Premise Data. They are requesting their "own" enterprise Gateway to be able to control the connection and refreshs indepentdently. My concern is the ability / capacity to support many data gateways and avoid redundant connections to servers that may already have a data source mapped to a current gateway.  They do not want to do a person gateway as they would like to maintain refreshes on a daily basis. 

At the same time I don't know how to understand the capacity of our current Gateway to best understand if we need to make a cluster, increase ram, or start to deploy seperate gateways. 

I have reviewed all the Microsoft Docs and I haven't found any good recommendation based on balancing Users and Adminstration of Gateways, closest thing I have found is on Rad Cad's site Power BI Gateway - All you need to know 

Any recommendation or help would be greatly appreciated!

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft]

Hi @Anonymous ,

Based on this document, To help avoid a single point of failure, you can set up on-premises data gateways as clusters for high availability. By default, cloud services such as PowerApps and Power BI use the primary gateway and fall back to the secondary gateway if the primary is unavailable. We can also change the setting to Distribute requests across all active gateways in this cluster.

The user of data source is the People who can publish the reports that use this data source, but the Administrators of gateway is the people who can administer the gateway (such as add/delete the data source, user)

If you want to monitor Gateway performance, you can refer to this document: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.