Connect On-Premise SAP Hana DB to Power BI Reports in Cloud

[Anonymous]

One of my client have the source system as SAP Hana DB as a On-Premise solution.

He also have the Office 365 Power BI pro license.

He wants me to connect the On-Premise SAP Hana DB to Power BI reports and host it in Power BI cloud service.

There are some reports where i need to make a live connection between the On-Premise SAP Hana DB and Power BI report and some other reports where i need to make a scheduled refresh too.

I understand that we can connect the On-Premise SAP Hana DB to Power BI desktop using the required drivers installed in the local machine. However once we host the report to cloud service how to obtain the connectivity between On-Premise SAP Hana DB and Power BI cloud service ?

[Icey · Accepted solution]

Hi @Anonymous ,

Hope these documents could help you:

Connect to SAP HANA databases in Power BI Desktop;

Connect to SAP HANA data sources by using DirectQuery in Power BI;

Manage your data source - SAP HANA.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.