Connect to sap HANA Database from Microsoft power BI(Business Intelligence)
Introduction: For Building dashboards in Microsoft Power BI(Business Intelligence) tool using Hana database as a source we need to enable the ODBC driver in the system to connect to Hana database. Please follow below steps to configure and build dashboards on Hana database(Calculation views)
Install HDB client software in system where you want to connect Hana Database. Hana client software enables the ODBC Driver as below.
Type odbc in windows search bar and click ODBC data source 32/64 bit
Click add on dBase
Double click on HDBODBC
Enter below details and save the connection.
Host : Hana database host
Instance number as example 00
And tenant database would be Hana system name
Step4: go to power BI and go to Hana database connection.
Enter username and password of SAP Hana Database
Conclusion: With following above steps We can connect to SAP Hana Database from Microsoft Power BI and we can use import or direct query connection to consume Hana calculation views or Hana reporting objects
Note: For Direct queries we need to configure certificate so that refresh of data can happen on the live
I enjoy working with Microsoft Power BI.This free program can recognize and connect to over 70 data sources. For example, xlsx, csv files, txt, data from SQL databases. It can also cleanse the data or process it and bring the entire million tablets to a single data model. Or you can define your own custom metrics that are used specifically in your company. By the way, I recently started using power bi integration with jira . This gives me the ability to quickly export the data I need to build my models. Convenient, simple and fast
Power BI desktop not fetching all the HANA calculation views
I successfully connected to the SAP HANA database from Power BI Desktop application, but Power BI desktop not showing all the content from the HANA. Any reason why and how this can be solved?
Power Bi version - 2.93.981.0 64-bit (May 2021)
Thanks for sharing, I just want to ask from where I can find out the host and port name, Also it's tenant database name if I am using SAP HANA XSA ?
You can check with your Basis team to find the exact host and port details. Even i had issues with the ones I tried getting from login to sap launchpad and go to system on the top and click parameters or services where we can get host name, Not sure how se can get in HANA XSA.
Hi Avinash Darapureddy
Can you please help on the user level configuration to be done ie., privilege's to be provided and roles to be assigned for the user in HANA, which is being used to connect to Power BI,
We have an issue where all the Schemas are getting reflecting in the Power BI when we connect we require only selected schema to be shown.
We also had issues with security. We created everything on composite providers so that sap Access is cascaded to Power BI. Other option for you would be to create roles in Power BI and assign to users. Few links might be useful