Skip to main content

Power BI

Needs Votes

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

Vote (51) 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

Priya Jacob on 05 Jul 2020 23:52:17

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

In Jul now and have already checked in the Jun 19 release and this is still not available - plz. have this enabled at the earliest. Else we are unable to make progress with PowerBI when it comes to SAP BW.

's profile image Profile Picture

Leon on 05 Jul 2020 23:46:59

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

April 2019 version still doesn't support it. You're forcing us to use Tableau/Lumira. OData works fine but we can't use it for significant data volume.

's profile image Profile Picture

Claudia Gerbersmann on 05 Jul 2020 23:37:36

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

Absolutely vital for us - otherwise PowerBI is worthless for us. All our SAP systems are behind routers.

's profile image Profile Picture

Ilya on 05 Jul 2020 23:16:59

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


Is there really no way to connect to SAP bw if it's behind the SAProuter? Can someone knows the ways?

's profile image Profile Picture

Dave on 05 Jul 2020 23:16:38

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

Connecting Power BI to SAP (whatever flavour) is not a nice to have but a requirement, since connections made to SAP through a SAP router leverage landscape security. I dont understand why Microsoft did'nt delivered this standard (not so hard to buildin a connection string entry in a window).

For the time being SAP projects are avoiding the use of power BI. SAP router is one of the reasons mentioned.

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:10:48

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

Hi,
Thanks for enabling connectivity with SAP BW using message server; but when we can expect the same to be available from enterprise gateway?

's profile image Profile Picture

Jim on 05 Jul 2020 23:10:20

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

My organisation only allows access to SAP BW using SAP router strings.

's profile image Profile Picture

Daniel LEMEE on 05 Jul 2020 22:55:18

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

I'm agree it's an issue... I like Power BI, but if we cant use Power BI to connect to SAP because tou don't support SAP router, we will use an other tool...

's profile image Profile Picture

Twan Jans-Beken on 05 Jul 2020 22:48:15

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

My organisation is moving to a new datacentre and access to SAP BW is then only possible using SAP router strings.

's profile image Profile Picture

Nikki Bosch on 05 Jul 2020 22:45:35

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

This is indeed vital! At this moment we cannot access the SAP data directly.