Skip to main content

    Power BI

    Needs Votes

    Connect to SAP BW with SSO

    Vote (986) 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

    Gautier Vallat on 05 Jul 2020 22:16:37

    RE: Connect to SAP BW with SSO

    SAP Business Object is a must. By allowing such connection we could leverage on the investments made on BO universes.

    So please consider adding SAP BO as a datasource.

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:16:28

    RE: Connect to SAP BW with SSO

    Sap Business Objects

    Philip Botterill's profile image Profile Picture

    Ashish Ruparel on 05 Jul 2020 22:15:55

    RE: Connect to SAP BW with SSO

    Hi Miguel,

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6917475-business-objects refers to Power BI Designer and is marked as complete. The ask here is for the BO data source in Power BI Desktop.

    When will that be made available ?

    Philip Botterill's profile image Profile Picture

    Paul on 05 Jul 2020 22:15:28

    RE: Connect to SAP BW with SSO

    SAP BusinessObjects BI Universe

    Philip Botterill's profile image Profile Picture

    Michael on 05 Jul 2020 22:13:19

    RE: Connect to SAP BW with SSO

    SAP ECC

    Philip Botterill's profile image Profile Picture

    Justin stadler on 05 Jul 2020 22:13:00

    RE: Connect to SAP BW with SSO

    Just want to second the ability for powerbi to use the universe web services would be most excellent.

    Philip Botterill's profile image Profile Picture

    Nick on 05 Jul 2020 22:13:00

    RE: Connect to SAP BW with SSO

    We are an SAP house so real time dashboards from our SAP HANA, ECC and BW. Priority in that order.

    I believe you now have a HANA connector that we are working with our Microsoft Account team to investigate. This would be very useful.

    Today we mostly leverage SAP BW and have built BO universes on top of our existing datasets. To contemplate a global migration to Power BI we would need to leverage this existing investment and have a secure and efficient pull of data at runtime to minimize data security challenges and minimal replication of data between our systems.

    Today we also use the data access authorisations from our SAP systems. Tapping into this so prevent building a new data security layer would also be a game changer.

    Philip Botterill's profile image Profile Picture

    santiago.aguado on 05 Jul 2020 22:12:56

    RE: Connect to SAP BW with SSO

    SAP BW will be fantastic

    Philip Botterill's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:12:37

    RE: Connect to SAP BW with SSO

    data generated from a business objects universe would be great

    Philip Botterill's profile image Profile Picture

    Paul on 05 Jul 2020 22:10:32

    RE: Connect to SAP BW with SSO

    ECC

    Merged Idea (1)