Single-sign-on for connection to SAP BW

[psakharshete]

Connector to SAP BW has enabled the easy access to data in SAP BW. However, scheduling the data refresh from SAP BW is not possible since the SSO feature is not available. This would be a good step to create dashboards using Power BI consuming SAP BW data.

[nishalit]

Check https://docs.microsoft.com/en-us/power-bi/service-gateway-sso-overview for more details

[balaji_rajaman1]

This is critical to ensure BW data is not getting duplicated outside BW

[cgolding]

I agree that single sign on for SAP BW connector is a requirement for a production rollout in our company. All of our applications, including SAP BW are single sign on. Without single signon we would be inundated with requests for manual password resets in our BW environment.

[babiarz_konrad]

Will this enable the Row Level Security when SSO will be working os SAP BW?

[glamoureux]

If only you knew the power of the SSO. It is your destiny! Join me, and together, we can rule the BW environment as programmer and query !

[nicolas_lejeun2]

We are actually looking for one analytics plateform and SSO is a requirement. I know that Tableau have now SSO, can you confirn it will be implemented in 2017 on Power BI ?

[morris_ward]

Miguel, is there a roadmap for other single sign on connections to source data via the Gateway? Even if it's a rough estimate by quarter or even year, it will help us to communicate the direction to upper management. The only that I'm aware of at this point is SAP.

[harry_leboeuf4]

It is not really a idea i'm posting, more a consideration hoping to find out how you guys are thinking about it, how it wil be implemented .. In the DirectQuery mode, by Gateway, the users connects to PowerBi.com with his Office365 account. In SQL models you can build a security system with logins and roles ... But in many cases SAP uses its own usersnames and restrictions to data. How will we be able to 'translate' the windows logon towards the SAP logon, because if the gateway is running with a 'See-All' user all connected users might also see all, in our case defenitly no option. As we can'd add any tables, calculated columns I don't see a way to play with the role-system ... So, how will/might this be handled ?

[rub1]

Do you have a deadline for this, as this has not been an update about this since January. This is something our company is awaiting for quite a while now.

[psakharshete2]

Any update on this request?