Forum Discussion

mamra4's avatar
mamra4
Regular Visitor
2 years ago
Solved

Cluster gateways

Hi, I have a power bi with two ms sql server datasource. The servers are in defferent network. I tried to install on-premise data gateway on the first server and on the second, install it as cluste...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    1. DO NOT install a Power BI Gateway on a VM that runs anything else. They will mercilessly starve each other of memory and compute power, and will quickly kill your disks/SSDs. Use dedicated VMs for your gateway cluster members.

    2.  While geographically diverse gateway cluster VMs are good for business continuity they are usually bad (very bad) for performance due to the network latency differences.  Ideally your gateway cluster members should be logically and physically close to your main data sources.

    3. If you have firewalls between your different networks you need to factor in the maintenance cost of opening ports between the networks. Remember that gateway cluster members must have free line of sight to the data sources. Gateways have no idea what a VPN is or how to establish one dynamically

    4. Remember that all on-premise data sources in a semantic model must be served by the same gateway cluster. That means if your networks are sufficiently walled in then you may need separate gateways in each of the networks.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mamra4 ,
Based on your description, first, make sure that both SQL Server instances are configured to allow remote connections. Error 26 is usually caused by not allowing remote connections. For Power BI Services or Power BI Desktop, you can connect directly to each data source. If you need to load data from two different SQL servers, you can create multiple data connections in Power BI Desktop, each corresponding to a SQL server. You can then combine this data using Power BI's data integration features, such as Merge, Append, or Copy/Paste data. Gateway clustering is primarily used for high availability and load balancing, but it can also facilitate connections to multiple data sources across different networks, provided that each gateway in the cluster has access to its designated data source.

Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Learn
Plan, scale, and maintain a business-critical gateway solution | Microsoft Learn
Troubleshoot the on-premises data gateway | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly