Forum Discussion
How connect RISE with SAP CLOUD FROM Power BI
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
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.