Forum Discussion
How connect RISE with SAP CLOUD FROM Power BI
Hi All,
How to connect RISE with SAP cloud from Power BI and what are the prerequities.
Thanks,
Bhaskar Kolli
Install Necessary Drivers:
Download and install the SAP HANA ODBC driver from the SAP Software Download Center.
Configure ODBC Data Source:
Open the ODBC Data Source Administrator on your machine.
Create a new data source using the SAP HANA ODBC driver.
Enter the SAP HANA server details, including host and port.
Connect in Power BI:
Open Power BI Desktop.
Select Get Data > ODBC.
Choose the configured ODBC data source and authenticate with your SAP credentials.
For more details please check this documentation : Power Query SAP HANA database connector
If this post helped pease do give a kudos and accept this as a solution
Thanks In Advance
7 Replies
Install Necessary Drivers:
Download and install the SAP HANA ODBC driver from the SAP Software Download Center.
Configure ODBC Data Source:
Open the ODBC Data Source Administrator on your machine.
Create a new data source using the SAP HANA ODBC driver.
Enter the SAP HANA server details, including host and port.
Connect in Power BI:
Open Power BI Desktop.
Select Get Data > ODBC.
Choose the configured ODBC data source and authenticate with your SAP credentials.
For more details please check this documentation : Power Query SAP HANA database connector
If this post helped pease do give a kudos and accept this as a solution
Thanks In Advance
Hi Bhaskarkolli9 ,
Thank you Akash_Varuna for the prompt response!
I wanted to check and see if you had a chance to review my previous message or Please let me know if everything is sorted or if you need any further assistance.
If it resolved, consider accept the solution that helped you as accept as solution.Hi Bhaskarkolli9 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.Is it support only direct query ?
Hi Bhaskarkolli9 ,
Thank you for the follow-up.I would be happy to assist you!Power BI supports both Import and DirectQuery modes when connecting to SAP HANA, but only when using the SAP HANA connector.
If you're connecting via ODBC, only Import mode is supported. For DirectQuery, we recommend using the native SAP HANA connector instead.
You may find more details here:
Power Query SAP HANA database connector - Power Query | Microsoft Learn
Hope this helps.If so,consider accepting it as solution.
Regards,
Pallavi.
Hi Bhaskarkolli9 ,
I wanted to check in on your situation regarding the issue.I hoe the issue got resolved,if so, please consider marking the reply that helped you or sharing your solution.
Thank you.Hi Bhaskarkolli9,
If your RISE environment is SAP S/4HANA Cloud Private Edition, you may also evaluate Power BI Connector for SAP:
It reads activated SAP OData services through SAP BTP Destination and Cloud Connector and provides Power BI with an OData endpoint, without requiring direct HANA database access or local HANA ODBC. It is an Import/refresh approach rather than HANA DirectQuery.
Documentation:
https://metricasoftware.com/docs/sap/Cheers,
Metrica Team
