{"id":51959,"date":"2023-12-07T15:20:58","date_gmt":"2023-12-07T14:20:58","guid":{"rendered":"https:\/\/www.cubeserv.com\/power-bi-use-sap-datasphere-data-with-high-performance\/"},"modified":"2023-12-24T18:23:18","modified_gmt":"2023-12-24T17:23:18","slug":"power-bi-use-sap-datasphere-data-with-high-performance","status":"publish","type":"post","link":"https:\/\/www.cubeserv.com\/en\/power-bi-use-sap-datasphere-data-with-high-performance\/","title":{"rendered":"Power BI: Use SAP Datasphere data with high performance"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Imagine this: You create a dashboard in Power BI (PBI) Desktop and your data is in SAP Datasphere<\/a>. How do you deal with this? There is already an established solution that uses the HDBODBC driver to access data from SAP Datasphere. This can be found on the following page:<\/p>\n

Consuming data from SAP Datasphere into Power BI via ODBC connector<\/a><\/p>\n

Although this connection can be established effortlessly and quickly, it has disadvantages, especially in terms of the limitation of real-time data updates.<\/p>\n

But what if your business scenario requires more than one Datasphere ODBC connection?<\/p>\n

If your business scenario is restricted by the Datasphere ODBC interface and cannot be ideally implemented, I will introduce you to an alternative solution in this blog – the HANA<\/a> Connector.<\/p>\n

This solution offers you seamless integration so that you can visualize and analyze the data in Power BI Desktop while it can be processed in SAP Datasphere at the same time.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

From SAP HANA Cloud to Power BI - A look behind the scenes<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The focus is on making the data from Datasphere visible in the HANA HDI container.<\/p>\n

The resulting Calculation View, which is created in the container, can be called up in Power BI as well as in other tools.<\/p>\n

The connection to Power BI is made using the SAP HANA Connector, which acts as a bridge between the HANA database and the Power BI Desktop. This solution makes it possible to visualize and analyze the data in Power BI Desktop, while the data can be further processed in SAP Datasphere.<\/p>\n

The procedure consists of the following steps, which are implemented in various systems:<\/p>\n

    \n
  1. Installing the SAP HANA ODBC driver<\/strong> https:\/\/tools.hana.ondemand.com\/#hanatools<\/a><\/li>\n
  2. Creating the Business Technology Platform (BTP) Pay-To-Go account<\/strong>\n