SAP Business Warehouse connector include SAP router string

[james_ives-plun]

My organisation only allows connectivity to the SAP BW system (or any SAP system) using the SAP router string. It would be beneficial to allow this type of connectivity rather than just providing the application server.

[Sebastian_Smera]

For many companies the missing SAP router string makes PowerBI a dead end

[pbiideas1]

'Hi, I did some research and it should be easy to add: - Power BI does use the standard .NET connector from SAP (see https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector#installation-of-implementation-20-sap-connector) - The documentation for this thing is at http://logosworld.com/docs/SAP/Connector/SAP%20Connector%20for%20Microsoft%20.NET%20%20NCo_30_ProgrammingGuide.pdf - Page 41 of the documentation shows that this is just another attribute to the connection string regards

[fbcideas_migusr]

Customers want to use a secure connection to their SAP backend using the SAP Router as a governance issue. This is blocking Power BI adoption.

[378071]

Hi, this is holding our capabilities to use Power BI for reporting. Need to connect to SAP.

[vkuren]

Maybe power bi not support connection to SAP BW with SAP Router?

[llejeune]

Tis feature is absolutely needed by some of my customers

[nishalit]

This is now complete.

Power Query SAP Business Warehouse Message Server connector - Power Query | Microsoft Learn
Power Query SAP Business Warehouse Application Server connector - Power Query | Microsoft Learn