Skip to main content
Microsoft Idea

Power BI

Needs Votes

Connect to SAP BW with SSO

Vote (983) Share
Philip Botterill's profile image

Philip Botterill on 11 May 2018 17:06:28

Connect to SAP BW with single-sign-on via on-premise gateway

Large SAP BW installations with thousands of users are often accessed via single-sign-on (SSO) e.g. the users windows credentials are used to authenticate to BW. SSO simplifies the user experience and reduces user administration costs. These users should be able to setup on-premise gateway connections that can be used to refresh data sets in the Power BI Service. The connections should leverage that individuals BW roles & authorizations and not require a BW password i.e. automatically associate the Power BI user ID to the associated SAP user ID.

Comments (101)
Philip Botterill's profile image Profile Picture

Arup Chatterjee on 05 Jul 2020 22:00:43

RE: Connect to SAP BW with SSO

SAP BW pls. I am completely pushing my IT & management to switch to PowerBI for daily analytics.

Connectivity to SAP BW will change the game.

Currently download data from BW through BEx in Excel to take advantage of PowerBI.

Philip Botterill's profile image Profile Picture

Power BI User on 05 Jul 2020 22:00:15

RE: Connect to SAP BW with SSO

As Power BI competes with the SAP Self Service Solution Lumira, which offers full BW Support, connectivity should be a top priority.

Many Small/Mid Companies use BW without BO and SAP is pushing Lumira intensively.

Philip Botterill's profile image Profile Picture

David Velazquez on 05 Jul 2020 22:00:09

RE: Connect to SAP BW with SSO

SAP BW will be a huge success!

Philip Botterill's profile image Profile Picture

Power BI User on 05 Jul 2020 21:59:58

RE: Connect to SAP BW with SSO

SAP BW

Philip Botterill's profile image Profile Picture

Juha Tuominen on 05 Jul 2020 21:59:18

RE: Connect to SAP BW with SSO

Connector for SAP BW would be nice.

Philip Botterill's profile image Profile Picture

Hemanth on 05 Jul 2020 21:59:15

RE: Connect to SAP BW with SSO

SAP BW and SAP ECC/R3 is a must

Philip Botterill's profile image Profile Picture

Brent on 05 Jul 2020 21:58:58

RE: Connect to SAP BW with SSO

SAP HANA would be a great source...

Philip Botterill's profile image Profile Picture

Thomas K on 05 Jul 2020 21:58:44

RE: Connect to SAP BW with SSO

In my mind the SAP Netweaver Gateway would be a good choice for all. The Gateway should be available for everyone with a Business contract automatically. On the other hand the GW is the promoted Connectivity method of the future in order to connect to non SAP Systems. All BAPI and RFC related Objects in ERP, BW and other Netweaver based products will be available via ODATA. So OATA in combination with Netweaver Gateway would be my choice.

Philip Botterill's profile image Profile Picture

Martin O'Connell on 05 Jul 2020 21:57:24

RE: Connect to SAP BW with SSO

Connectivity to SAP BW could be a game changer for Power BI. SAP tools for querying the data are not very user friendly. If Excel and/or Power BI Designer had SAP BW as a data connector (not the BO Universe connector), this would make life so much easier for end-users who would no longer have to wait on their IT department to do everything for them. Tableau has it, Power BI needs it!

Philip Botterill's profile image Profile Picture

Travis Clayton on 05 Jul 2020 21:56:59

RE: Connect to SAP BW with SSO

ERP connectivity then BW then HANA. All of my customers run SAP, this would really help drive adoption of PowerBI for our enterprise customers.

Merged Idea (1)