Forum Discussion
connect to SAP BW with Windows authentication (Single Sign-On)
Hi Everyone,
When I tried to connect to SAP BW with the "SAP Business Warehouse Application Server" connector and windows credentials, I got the following error message:
Details: "SAP Business Warehouse: RfcOpenConnection failed(RFC_COMMUNICATION_FAILURE):
LOCATION CPIC (TCP/IP) with Unicode
ERROR GSS-API(maj): No credentials were supplied
Unable to establish the security context
target="p:[email protected]"
I've filled in the SNC Parter Name and tried different options of SNC Library but all failed. However, I'm able to connect to BW with database credentials.
Has anyone tried with Single Sign-On? Any help is appreciated.
Thanks.
Thanks Sheng! The Dev 17 release mentioned Windows Authentication is supported for SAP BW, but looks like it’s not really functioning.
12 Replies
Hi krany,
Based on document, current power bi seems only support sue connection string to access to SAP BW datasource.
I haven't found any way to let single sign-on works with default SAP BW connector in power bi.Use the SAP BW Connector in Power BI Desktop
For your requirement, I'd like to suggest you create an odata instance with SAP BW datasource, then you can use power bi odata connector with windows authentication on ti.
Steps to Create an ODATA service for a BW Query
Regard,
Xiaoxin Sheng
Thanks Sheng! The Dev 17 release mentioned Windows Authentication is supported for SAP BW, but looks like it’s not really functioning.
Hello, i am trying to setup SSO from Power BI desktop client to SAP BW, but i am getting below when i am connecting to SAP BW
"Could not find a suitable SAP user for the SNC name of the caller", can you please let me know if you have found the solution and implemented
thanks
- rubensalvador
Advocate I
Hi Krany,
we have some issues with SSO, because our SAP BW SSO dll is 32bit and power bi desktop is 64bit.
Do you experience the same problem?
best regards
Rúben Salvador
Hi Ruben,
Did the SAP BW SSO worked with Power BI for you?
Please suggest the solution, if you could.
Thanks.
Nazeer
Hi Ruben,
Did the SAP NW SSO for BW worked for you?
Could you please share the solution, if possible. We are in middle of implementing the NW SNC SSO for SAP BW.
Appreciate your kind response.
Thanks.
Nazeer
- rubensalvador
Hi nazeer1232Nazeer,
I did managed to connect to BW using the new June version of PowerBI desktop 64 bit. Since then I have tested August version and I tested both the connection using SAP Netweaver (also called Implementation 1.0) and the new option to connect via SAP .Net connector 3.0 (in Beta still) (also called Implementation 2.0).
The .NET connectivity works better as it is more performant.
Both of them work well in relation to the SSO access to SAP BW, in terms of running within PowerBI desktop (using both Direct Query and Import connection types).
I tested these below scenarios:
1. SSO with Netweaver connection, using Import
2. SSO with Netweaver connection, using DirectQuery
3. SSO with .Net 3.0, using Import
4. SSO with .Net 3.0, using DirectQuery
When I published the 4 scenarios to the online platform I was only able to run scenarios 1 and 2. The .NET only works if you're using PowerBI desktop, and that can be explained by the fact that it's still in a Beta version.
I have also installed the new version of the gateway (August).
The problem I face is if I want to Share my dashboard/report via the online platform, in scenarios 1 or 2, the BW data that is retrieved is not the user I shared the report with, but instead the user that I have used when I created the Gateway DataSource. This obliges us to do double-maintenance in Roles, both in SAP BW and in PowerBI desktop (Row Level Security). This is our main reason why we haven't yet adopted the SAP BW connector.
hope I have helped,
Just let me know if you need some more insight
Rúben
