Skip to Content

Connect Microsoft Power BI to SAP Data Warehouse Cloud

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
rashidabdulrahimanRashid Abdul RahimanOctober 10, 2021
Created by
October 10, 2021
  • Step 1

    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
  • Step 2

    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.


    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
  • Step 3

    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.

    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.


    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.

  • Step 4
    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.

    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.


    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.

  • Step 5

    What must be done to all data entities in order to ensure they can be consumed by the BI tool of your choice?

Back to top