Skip to main content

Power BI

Needs Votes

Connect to SAP BW with SSO

Vote (985) 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 (100)
Philip Botterill's profile image Profile Picture

Gautier Vallat on 05 Jul 2020 22:16:37

RE: Connect to SAP BW with SSO

SAP Business Object is a must. By allowing such connection we could leverage on the investments made on BO universes.

So please consider adding SAP BO as a datasource.

Philip Botterill's profile image Profile Picture

Power BI User on 05 Jul 2020 22:16:28

RE: Connect to SAP BW with SSO

Sap Business Objects

Philip Botterill's profile image Profile Picture

Ashish Ruparel on 05 Jul 2020 22:15:55

RE: Connect to SAP BW with SSO

Hi Miguel,

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6917475-business-objects refers to Power BI Designer and is marked as complete. The ask here is for the BO data source in Power BI Desktop.

When will that be made available ?

Philip Botterill's profile image Profile Picture

Paul on 05 Jul 2020 22:15:28

RE: Connect to SAP BW with SSO

SAP BusinessObjects BI Universe

Philip Botterill's profile image Profile Picture

Michael on 05 Jul 2020 22:13:19

RE: Connect to SAP BW with SSO

SAP ECC

Philip Botterill's profile image Profile Picture

Justin stadler on 05 Jul 2020 22:13:00

RE: Connect to SAP BW with SSO

Just want to second the ability for powerbi to use the universe web services would be most excellent.

Philip Botterill's profile image Profile Picture

Nick on 05 Jul 2020 22:13:00

RE: Connect to SAP BW with SSO

We are an SAP house so real time dashboards from our SAP HANA, ECC and BW. Priority in that order.

I believe you now have a HANA connector that we are working with our Microsoft Account team to investigate. This would be very useful.

Today we mostly leverage SAP BW and have built BO universes on top of our existing datasets. To contemplate a global migration to Power BI we would need to leverage this existing investment and have a secure and efficient pull of data at runtime to minimize data security challenges and minimal replication of data between our systems.

Today we also use the data access authorisations from our SAP systems. Tapping into this so prevent building a new data security layer would also be a game changer.

Philip Botterill's profile image Profile Picture

santiago.aguado on 05 Jul 2020 22:12:56

RE: Connect to SAP BW with SSO

SAP BW will be fantastic

Philip Botterill's profile image Profile Picture

Power BI User on 05 Jul 2020 22:12:37

RE: Connect to SAP BW with SSO

data generated from a business objects universe would be great

Philip Botterill's profile image Profile Picture

Paul on 05 Jul 2020 22:10:32

RE: Connect to SAP BW with SSO

ECC

Merged Idea (1)