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

Dustin Fincannon on 05 Jul 2020 22:10:26

RE: Connect to SAP BW with SSO

Live data in ECC

Philip Botterill's profile image Profile Picture

Michael Goo on 05 Jul 2020 22:08:50

RE: Connect to SAP BW with SSO

I would like to have a connector to populate dashboards directly from SAP BusinessObjects universe.

Philip Botterill's profile image Profile Picture

James Pretorius on 05 Jul 2020 22:08:28

RE: Connect to SAP BW with SSO

The Power Query Connector in MS Excel supports the use of SAP BusinessObjects unx universes as a datasource.

It's possible to use dimensions, attributes and measures from the universe but it's not possible to utilise predefined filters built into the universe. This removes the ability for the Power Query end user to take advantage of SAP BusinessObjects functionality such as Index Awareness.

Predefined query filters are available through the SAP BusinessObjects RESTFul API, having the ability to utilise these would bring about both performance gains and improved ease of use for the Power Query end user.

Philip Botterill's profile image Profile Picture

German Viera on 05 Jul 2020 22:08:08

RE: Connect to SAP BW with SSO

I wish there is a direct connector between SAP ECC and PowerBI.

Philip Botterill's profile image Profile Picture

Aryathuyi on 05 Jul 2020 22:06:50

RE: Connect to SAP BW with SSO

For all SAP Customer requesting the Power BI to deliver as its front end reporting.Really Will there be a chance of getting the BW , HANA Connector. What about the SAP Native BI tool like Lumira , Design studio , Webi , Analysis for EXCEL , Crystal report , BOBJ 4.2 ?

Philip Botterill's profile image Profile Picture

Aryathuyi on 05 Jul 2020 22:06:50

RE: Connect to SAP BW with SSO

By the using the SAP GW Gateway it only supports 100000 records.

Philip Botterill's profile image Profile Picture

Micah Rairdon on 05 Jul 2020 22:06:49

RE: Connect to SAP BW with SSO

Business Objects!

Philip Botterill's profile image Profile Picture

Micah Rairdon on 05 Jul 2020 22:06:49

RE: Connect to SAP BW with SSO

Would like support for this in Power BI Desktop and Excel 2016

Philip Botterill's profile image Profile Picture

Shobhit Acharya on 05 Jul 2020 22:06:49

RE: Connect to SAP BW with SSO

Need confirmation from Microsoft on the future of PowerQuery -> BusinessObjects connectivity as well as wether the BusObj connector will ever be back in PowerBI ? This used to be a selling point for enterprise customers

Philip Botterill's profile image Profile Picture

Shobhit Acharya on 05 Jul 2020 22:06:34

RE: Connect to SAP BW with SSO

Also - the following "completed" response is inaccurate https://support.powerbi.com/forums/265200-power-bi/suggestions/6917475-business-objects

Merged Idea (1)