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)
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.
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.
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.
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?
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.
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?
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.
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...
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.
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.