Connect Microsoft Power BI to SAP Datasphere
- How to connect Microsoft Power BI to SAP Datasphere
- You have installed the ODBC Data Source Administrator (64-bit)
- You have installed an SAP HANA ODBC Driver
- You have created a database user
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.
- 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.
- 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:
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.
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
With the data now ready to be imported, open the Microsoft Power BI application from your system, and click on the Get Data icon.
Select ODBC from the list of connections and click on Connect.
Select the data source you have connected to ODBC from SAP Datasphere, and enter your database user credentials. Click on Connect once done.
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.
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.
- 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?