Power BI

Needs Votes

SAP

Vote (905)

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 (52)

Comments (52)

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:24:23

RE: SAP

This is a critical requirement for further roll out

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:23:36

RE: SAP

This is probably the single biggest barrier to further adoption and users in our company.

d07ad35e 7aa0-449d-9126-3d59c788d926 on 05 Jul 2020 23:23:31

RE: SAP

Connecting to BW via Direct Query in very large BW systems has some advantages but many disadvantages, including slowness and loss of many Power BI key features such as data mashup and transformations. As such, we do not recommend this option in our environment. With Import we can bring transparently the set of data the users need closer to them and allow them to mashup (adding local groupings and hierarchies) and add useful transformations that allows fixing wrong data, adjusting formats etc. However, the Import method does not have Cloud refresh, forcing users to refresh at desktop level and re-publish the whole set again and again. The new BW connector added spedd and mass processing capabilities, which is great. However, without the option to refresh Imported data in the cloud we still have no viable BW connection option to recommend to our users.

52f02309 d206-4d59-9f45-24662a77cbfb on 05 Jul 2020 23:23:20

RE: SAP

We are running HANA on top of BW and RLS is established at the BW layer. We need the above stated issue to be resolved in order for RLS to work properly...

a4347073 963b-45b6-b060-63f4cb3207bb on 05 Jul 2020 23:22:57

RE: SAP

it's so usefull to my organization!! implement it ASAP

6b42bce0 ee6f-476d-94f4-9fa269dca2be on 05 Jul 2020 23:22:13

RE: SAP

In our organisation we are using BW and the only way allowed to authenticate is SSO, which makes it impossible to use BW from PBI Cloud without possibility to pass credentials through the gateway.