PowerBI report server to SAP BW

[akshayp20]

Hey Folks,

Has anyone been able to get the powerBI report server to use reports published from SAP BW? My question is very specific to getting SSO to work for users connecting to powerBi report server published report wherein they are not asked for a user/password ? 

For now, we are able to create and publish report with basic authentication in the report server properties, but how do I get SNC/SSO to work ? I do not see an option to do so in the powerBI report server. I can see snc options in the desktop, but as end users how can they run the report using SNC which is configured on the bw side already for SAP GUI SSO. 

Please note there is no cloud component involved here, it's all on prem including an on prem AD. Any inputs or guidance towards this will be greatly appreciated as we are struggling to get this to work end to end.

Thank you,

Akshay Pandit

[Anonymous · Accepted solution]

Hi @akshayp20 ,

For SAP Business Warehouse server data source only support Username and Password authentication methods, does not support SSO.

For more details, you could read related document: Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.