Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Connect to SAP BW with SSO

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.
Status: Needs Votes
Comments
pbiideas1
New Member
We need this connectivity working for both BW and ECC systems.
vishwanath_math
New Member
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 .
andrew_z_dyer
New Member
We are using SAML to authenticate to our SAP ECC. Support for SAML would be great.
muhammad_rafiqu
New Member
We need this connectivity working for both SAP BW and PBI
a_pianigiani
New Member
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
mohammedali2011
New Member
Visa,Resident Permit http://Glorecdoc.com
ankit_jampot
New Member
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
harish_madari1
New Member
SAP ECC Connector in Power BI Desktop is a major ask in our organization.
olivier_robin
New Member
Please prioritize this functionality to unlock the use of SAP data
9188040d-6c6311
New Member
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/)