How connect RISE with SAP CLOUD FROM Power BI

[Bhaskarkolli9]

Hi All,

How to connect RISE with SAP cloud from Power BI and what are the prerequities.

Thanks,

Bhaskar Kolli

[v-pagayam-msft]

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.

[v-pagayam-msft]

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.

[Bhaskarkolli9]

Is it support only direct query ?

[v-pagayam-msft]

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.

[v-pagayam-msft]

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.

[Akash_Varuna · Accepted solution]

Hi @Bhaskarkolli9 

• 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