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

    Mark Schneeberger on 05 Jul 2020 22:06:28

    RE: Connect to SAP BW with SSO

    HANA, ECC and then BW

    Philip Botterill's profile image Profile Picture

    Roland Essmann on 05 Jul 2020 22:02:55

    RE: Connect to SAP BW with SSO

    Please add Universe connector again

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:02:51

    RE: Connect to SAP BW with SSO

    Hi,
    PowerQUery in excel does supprt SAP universe as data source so not having same option in PoewrBI app does not make sense. Also same option was available when PowerBI desktop app was in preview.
    It would be very important data source to have.

    thanks,
    Dilkush

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:02:36

    RE: Connect to SAP BW with SSO

    BW and HANA, in that order. We are one of those comp using HANA for native data marts.

    Philip Botterill's profile image Profile Picture

    DAR on 05 Jul 2020 22:02:26

    RE: Connect to SAP BW with SSO

    HANA

    Philip Botterill's profile image Profile Picture

    Luciano Barragan on 05 Jul 2020 22:01:42

    RE: Connect to SAP BW with SSO

    ECC & HANA

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:01:09

    RE: Connect to SAP BW with SSO

    BW and HANNA

    Philip Botterill's profile image Profile Picture

    Doug Shagam on 05 Jul 2020 22:00:59

    RE: Connect to SAP BW with SSO

    BW!

    Philip Botterill's profile image Profile Picture

    Naiem Zohrri on 05 Jul 2020 22:00:48

    RE: Connect to SAP BW with SSO

    Perhaps via the new SAP Gateway for Microsoft

    Philip Botterill's profile image Profile Picture

    Arup Chatterjee on 05 Jul 2020 22:00:43

    RE: Connect to SAP BW with SSO

    SAP BW pls. I am completely pushing my IT & management to switch to PowerBI for daily analytics.

    Connectivity to SAP BW will change the game.

    Currently download data from BW through BEx in Excel to take advantage of PowerBI.

    Merged Idea (1)