Skip to Content

Connect Microsoft Power BI to SAP Data Warehouse Cloud

test
0 %
Connect Microsoft Power BI to SAP Data Warehouse Cloud
Details

Connect Microsoft Power BI to SAP Data Warehouse Cloud

October 10, 2021
Created by
October 10, 2021
In this tutorial, you will learn how to connect your SAP Data Warehouse Cloud tenant to Microsoft Power BI.

You will learn

  • How to connect Microsoft Power BI to SAP Data Warehouse Cloud
QR code


Step 1: Add your IP address to IP allowlist

To allow an external BI client in your local network to connect to the database of SAP Data Warehouse Cloud, you need to add the external (public) IPv4 address of the client to an allowlist.

To do so, navigate to the Configuration screen on the bottom left of your SAP Data Warehouse Cloud tenant. Here, you can find the IP Allowlist tab, where you can simply click on Add and enter the IPv4 address of your system to add it to the allowlist.

IP Allowlist

Log on to answer question
Step 2: Ensure entities in SAP Data Warehouse Cloud are consumable

In order to ensure the data entities and models created in your SAP Data Warehouse Cloud tenant are consumable by the BI tool of your choice, it is important to expose them for consumption.
If the entity was created in the data builder, simply click on the entity and set the Expose for Consumption toggle to ON as below.

Consumable

If the entity was created in the business builder, the toggle shows up as a Allow public data access checkbox in it’s properties tab. Simple click on the data entity to open it, and ensure the checkbox is ticked.

Public Data Access

Log on to answer question
Step 3: Create an ODBC data source

The next step to connecting Microsoft Power BI to SAP Data Warehouse Cloud is creating an ODBC data source. This data source must point to the SAP Data Warehouse Cloud schema using the database user credentials you already have created. To create an ODBC data source, follow the steps below:

  1. Open the ODBC Data Source Administrator (64 bit) application. Click on Add to add a new data source. Select and add the SAP HANA ODBC driver you have earlier installed. The driver is named HDBODBC.

    ODBC
  2. On the configuration screen, enter the same connection credentials as that of your database user. Ensure that the Multitenant box is unchecked, and the Connect to the database using TLS/SSL box is checked.

    Connect

In case the driver cannot be found, re-install it from the SAP HANA development tools website. The ODBC driver used in this example is version 2.4.177.

Log on to answer question
Step 4: Connect Microsoft PowerBI to SAP Data Warehouse Cloud
  1. With the data now ready to be imported, open the Microsoft Power BI application from your system, and click on the Get Data icon.

    Get Data
  2. Select ODBC from the list of connections and click on Connect.

    ODBC
  3. Select the data source you have connected to ODBC from SAP Data Warehouse Cloud, and enter your database user credentials. Click on Connect once done.

  4. Your data now appears in the navigator. Select the data entities you wish to work with, and click on Load.

And that’s it! The data is now available in Microsoft Power BI and can be used to create reports and charts for analysis.

Charts

Well done!

You have completed the connection to BI tools tutorial group. Now it’s time to continue learning. Please check out the other SAP Data Warehouse Cloud tutorials available here, and don’t forget to follow the SAP Data Warehouse Cloud tag in the SAP Community to hear about the most up to date product news.

Log on to answer question
Step 5: Test yourself
What must be done to all data entities in order to ensure they can be consumed by the BI tool of your choice?
×

Next Steps

Back to top