How to connect to sap Hana database from power Bi?


How to connect to sap Hana database from power Bi?



Below are the set of steps to be followed to connect to SAP HANA database from the Power BI:

Navigate to Get Data.
Go to the database and also select the SAP HANA.
For the Hana Connectors, click here:
Download and complete the installation.
Type in the server name.
Type any Sql statements if needed. This is optional.
Select the mode of authentication (window/ database).
You will need to select the required tables and fields residing in HANA for creating the reports and visualization.
You will need to connect the data through import (for less data/offline) or direct query (metadata/ online) to Hana.
Click on the OK button.
With this, the data will be retrieved and will be ready for creating the visualizations.


If you want to unleash your potential in this competitive field, please visit the SAP course page for more information, where you can find the SAP tutorials and SAP frequently asked interview questions and answers as well.


This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.