How to connect to sap Hana database from power Bi?

0 votes
How to connect to sap Hana database from power Bi?
Mar 22, 2019 in Power BI by Anitha
3,344 views

1 answer to this question.

0 votes

Hi,
Follow these steps to connect to data source from Sap Hana:
1. Click on Get Data.
2. Go to Database and select SAP HANA.
3. For Hana connectors, click here https://support.sap.com/en/product/connectors.html .
4. Download and install the same.
5. Then Type your server name.
6. Type any Sql statements. (optional).
7. Select mode of authentication (window /database).
8. Select required tables and fields residing in Hana for creating your report and visualization.
9. Connect data through import(for less data/offline) or direct query(metadata/online) to Hana.
10. Click Ok.
11. Now the data is retrieved and is ready to create visualizations.

Hope this helps you.

answered Mar 22, 2019 by Cherukuri
• 32,490 points
what do you mean by Download and install the same, which connector should I choose
Hi,

Regarding your issue, I would suggest you go through this:https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-hana

Related Questions In Power BI

+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,490 points
11,694 views
0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,490 points
342 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 51,970 points
785 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23, 2019 in Power BI by anonymous
• 32,490 points
2,528 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,120 points
247 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,120 points
1,275 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,420 points
338 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 51,970 points
349 views
+1 vote
3 answers

How to connect to oracle database from power Bi?

I use Devart ODBC drivers in order ...READ MORE

answered Dec 20, 2019 in Power BI by Tony
• 160 points
10,483 views
0 votes
1 answer

How to connect to IBM DB2 database from power Bi?

Hi, Hi, Follow these steps, to connect to IBM ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,490 points
4,450 views