Skip to main content

Power BI

New

SAP BW Message/Group server connectivity to get advantage of load balancer

Vote (50) Share
's profile image

on 16 Oct 2017 11:59:20

Power BI allows us top connect to SAP BW system by providing details of server name, instance & client. But it does not have a mechanism to connect with SAP BW message server or group server (with dynamic selection of application server along with instance). Due to this limitation we are only able to connect with a specific application server. As a result it can create huge load in specific server and crash the same. But otherwise if we could connect to message/group server the Load Balancer would have equally distribute the load.

So can you implement the same for both Power BI Desktop and Gateway.

Comments (12)
's profile image Profile Picture

da6768b7 5756-4e39-91ff-f50e0236ba60 on 05 Jul 2020 22:35:52

RE: SAP BW Message/Group server connectivity to get advantage of load balancer

Yes, agreed! All our SAP Systems are only reachable through a SAP router!

's profile image Profile Picture

a66bf204 28bc-4101-8950-b44e1e02a560 on 05 Jul 2020 22:32:37

RE: SAP BW Message/Group server connectivity to get advantage of load balancer

It's vital to have an ability to establish a connection to the SAP BW instance using the SAP Router string