On-premise Power BI Report Server to On-premise SAP HANA SSO / SAML connection

[kumars]

Dears, we have an On-premise Power BI Report Server and On-premise SAP HANA.

Would anyone guide to establish a connection with proper SSO / SAML configuration ?

Kindly note: we have searched already and most of the links lead to Power BI cloud / service which is not our scenario.

Thank you in advance.

[sevenhills]

There are two things, 

First is paginated reports, which are nothing but SSRS reports.

In the past, I was able to connect SAP HANA using ODBC and use it in SSRS as Data Source. 

In order to connect to SAP HANA.

1) Create a System DNS- from control panel- to connect to SAP HANA

2) Use the System DNS as your datasource in your SSRS-Sources

Second is Power BI .pbix files on PBIRS, Check these and see if it helps

https://blogs.sap.com/2021/03/19/connect-to-sap-hana-database-from-microsoft-power-bibusiness-intell...

https://learn.microsoft.com/en-us/power-query/connectors/sap-hana/overview 

https://learn.microsoft.com/en-us/power-query/connectors/sap-hana/configure-odbc-sap-hana