Forum Discussion
connect to SAP BW with Windows authentication (Single Sign-On)
Thanks Sheng! The Dev 17 release mentioned Windows Authentication is supported for SAP BW, but looks like it’s not really functioning.
Hi Ruben,
Thank you for reverting back with a detailed response. I really appreciate your kind explanation and findings.
I am proceeding with the below steps for implementation method 1.0 at the moment. Interesting note, what I experienced in past (not using SAP BW, but Sybase IQ) is the fact that the Power BI Desktop connection user should be same as that of DataSource on the Gateway configuration. I used ODBC generic connection to establish rather defining individual users. However, in my current case I require SAP BW end-user with SSO (SNC) enabled to access the Power BI Desktop as power user.
How will it work if I have 20 such power users, will I require to maintain 20 power gateway connections :(
Please suggest if you have found any work-around?
Thanks a lot.
Cheers !
Nazeer
Advocate IHi Nazeer,
you can only have 1 gateway connection per DataSource installed in 1 server node. Therefore, that connection can only have 1 user defined. Once you publish your report to the online platform and you select the gateway all users will use that gateway.
If you only have power users editting that same report, then you profit on having that report in one unique APP workspace, so all can access and edit that same report. If all of you power users are OK to view all data without any restrictions I would say you won't have an issue, but if you want each of your power users to access different kind of data based on their SAP BW role, then, as I said, this is not possible. Only way is to implement Row Level Security.
regards,
Rúben
Hi Nazeer/Ruben,
I have been following your discussion and it seems you have cracked on using SSO while connecting to Power Bi. I have followed the White paper which tals about the connectivity and I am awaiting my organization SAP team to provide me the details SNC Partner name etc so that I can test the same. but I have few doubts and would request your help.
Where do I install SAPSetupSCL.exe in my Power Bi Desktop machine. Under which Folder?Will it be required for each user who is going to use Single Sign on functionality for SAP BW?
When you talk about option 1 2 3 and 4, Are you talking about connectivity through Application Server(1,2) and Message Server(3,4) if not what is it?
What are the other challenges we may come across?
It will be great if you document the steps and publish it as many organization are looking for this connectivity and no full proof document is available.
Thanks,
Ankku