How to connect to sap Hana database from power Bi?

SAP

How to connect to sap Hana database from power Bi?


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.

1
Answers

Replies

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: https://support.sap.com/en/product/connectors.html
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.

 
 

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.
WhatsApp
To Top