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

    Martin Poeckl on 05 Jul 2020 23:56:22

    RE: Connect to SAP BW with SSO

    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/)

    Philip Botterill's profile image Profile Picture

    olivier on 05 Jul 2020 23:50:05

    RE: Connect to SAP BW with SSO

    Please prioritize this functionality to unlock the use of SAP data

    Philip Botterill's profile image Profile Picture

    Harish Madari on 05 Jul 2020 23:39:25

    RE: Connect to SAP BW with SSO

    SAP ECC Connector in Power BI Desktop is a major ask in our organization.

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:33:37

    RE: Connect to SAP BW with SSO

    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

    Philip Botterill's profile image Profile Picture

    Alessio on 05 Jul 2020 23:31:50

    RE: Connect to SAP BW with SSO

    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

    Philip Botterill's profile image Profile Picture

    mohammedali on 05 Jul 2020 23:31:15

    RE: Connect to SAP BW with SSO

    Visa,Resident Permit http://Glorecdoc.com

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:29:55

    RE: Connect to SAP BW with SSO

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

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:29:09

    RE: Connect to SAP BW with SSO

    We need this connectivity working for both SAP BW and PBI

    Philip Botterill's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:27:45

    RE: Connect to SAP BW with SSO

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

    Philip Botterill's profile image Profile Picture

    vishwanath on 05 Jul 2020 23:27:23

    RE: Connect to SAP BW with SSO

    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 .

    Merged Idea (1)