Power BI Connection – SAP HANA (ODBC)
There are two ways to connect, the first through Hana Connector and the second via ODBC. Please note that all required programs must be supported; that is, POWER BI must have the same Hana Client distribution
1. HANA client installation, distribution according to the equipment(x32 or x64)
Unzip folder
Run as hdbsetup administrator; this installer will install the necessary ODBC connection driver, visual, as well as required add-ons
Caution: When an older version of Visual is installed, errors may be generated, ideally uninstalling the program manually and rerunning the installer
2. Once Hana Client is installed, it is necessary to configure the ODBC Data Source of your computer, note that this exists for each distribution (make sure to run as an appropriate administrator)
Once there, navigate to System DNS, choose the Add option, select HDBODBC; a dialog box will then appear asking for data associated with the name (name for the connection), description (to be assigned), server information
In addition there is an option to test connection, when selecting it, it will ask you for credentials. If the outcome is successful, the process was carried out properly
3. Enter Power BI > Get Data > More > ODBC > Connect(Button)
Configure with credentials
