Skip to main content

Power BI

Needs Votes

Connect to SAP BW with SSO

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