Skip to Content

Connect Microsoft Power BI to SAP Datasphere

10 min.
In this tutorial, you will learn how to connect your SAP Datasphere tenant to Microsoft Power BI.
You will learn
  • How to connect Microsoft Power BI to SAP Datasphere
jmmargojmmargoMarch 13, 2023
Created by
January 6, 2023

Please note that SAP Data Warehouse Cloud has evolved into SAP Datasphere. While some screenshots in this tutorial reference SAP Data Warehouse Cloud, the content applies to SAP Datasphere.

  • Step 1

    To allow an external BI client in your local network to connect to the database of SAP Datasphere, 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 Datasphere 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 in to complete tutorial
  • Step 2

    In order to ensure the data entities and models created in your SAP Datasphere 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
    Log in to complete tutorial
  • Step 3

    The next step to connecting Microsoft Power BI to SAP Datasphere is creating an ODBC data source. This data source must point to the SAP Datasphere 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.

    Log in to complete tutorial
  • 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 Datasphere, 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 Datasphere tutorials available here, and don’t forget to follow the SAP Datasphere tag in the SAP Community to hear about the most up to date product news.

    Log in to complete tutorial
  • 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?

    Log in to complete tutorial
Back to top