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)

a177333f 53d8-4088-8c88-705bc7054741 on 05 Jul 2020 23:56:22

RE: SAP

SSO works for Power BI & SAP (HANA + BW) using Kerberos (for PBI Desktop and PBI Service through the Gateway): https://docs.microsoft.com/en-us/power-bi/service-gateway-sso-kerberos.
SSO for SAP BW is supported since 04/2018 (https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-april-update-is-now-available/)

d0204c2c 310f-451d-bf65-8d62ebd84654 on 05 Jul 2020 23:50:05

RE: SAP

Please prioritize this functionality to unlock the use of SAP data

57b6ace4 18d9-4c14-bb28-b727ee0b5543 on 05 Jul 2020 23:33:37

RE: SAP

I dont know why its here , because I am able to do it using Single sign on I am using Message Server connectivity with >net connector and using Kerberos authentication. All you need is SAP Partner name which you can get from SAP Logon of your organization. No password required while connecting to SAP BW.

Correct me if i am wrong

08794f4e f26b-450f-ac1c-2b427b1ad28b on 05 Jul 2020 23:31:50

RE: SAP

Not only for BW but for ECC as well.
All main companies use SAP, the effort of replicating and keep securities syncronized on a datawarehouse for powerBI stops powerBI growth

7df03128 b87f-42a4-ac8f-8e97ad8c4c41 on 05 Jul 2020 23:31:15

RE: SAP

Visa,Resident Permit http://Glorecdoc.com

1149fb4f 105a-4adf-9c99-093218eafa91 on 05 Jul 2020 23:29:55

RE: SAP

We are using SAML to authenticate to our SAP ECC. Support for SAML would be great.

05f60615 269a-4493-8f1e-2c9a86d0581b on 05 Jul 2020 23:29:09

RE: SAP

We need this connectivity working for both SAP BW and PBI

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

RE: SAP

We need this connectivity working for both BW and ECC systems.

c91bb6c0 bc37-4ed3-95ef-78ea477db1a5 on 05 Jul 2020 23:27:23

RE: SAP

We need this in our organization as we have to leverage existing BW roles and authorizations instead of controlling the access at the report or a work space level.
Because of this missing SSO we are unable to use the power BI .

f4a4907c 99bc-4e93-b12e-84bf264268fd on 05 Jul 2020 23:25:27

RE: SAP

We need this in our organization!!
If this is possible, we will increase Power BI usage dramatically.