DirectQuery for SAP Datasphere from Microsoft Power BI


APOS Live Data Gateway extension for Microsoft Power BI provides fast, efficient and transparent data access through DirectQuery connections to SAP Datasphere. A DirectQuery connection is critical to handle medium to large datasets and cloud sources where importing data is prohibitive because of size. Only the information required, is retrieved.

Microsoft Power BI does not support a DirectQuery connection to SAP Datasphere. This is crucial to handling medium to large datasets that are stored in Datasphere.


Live Access to SAP Datasphere with Power BI

Power BI DirectQuery support to SAP Datasphere

Power BI DirectQuery support to SAP Datasphere

Enable Power BI reports and visualizations to display current, live SAP Datasphere data with Power BI DirectQuery with no need to import data into Power BI.

Immediate Access to Data

Immediate access to data

Access SAP Datasphere data immediately with no waiting for downloads or time delays associated with downloading data.

Data is Always Current

Data is always current

There is no latency of the data being analyzed, and the data is always current. No need to refresh data, which is critical with large volume data, or fast changing data.

Handle Big Data

Handle Big Data

Regardless of the size of the database being analyzed, only the data that is relevant to your needs is retrieved. Targeted queries/query results are being utilized during analysis.

Mitigate Security Issues

Mitigate security issues

Remove the security concerns of having large blocks of data imported and stored on local machines. Instead of needing to download full datasets, access only small data portions required for visualizations locally.


Connecting Microsoft Power BI to SAP Datasphere using DirectQuery

See how APOS Live Data Gateway for SAP Datasphere enables DirectQuery live connectivity from Power BI to SAP Datasphere


Live data access with DirectQuery

Why APOS Live Data Gateway?


DirectQuery provides live data connectivity to data assets, which allows Power BI reports and visualizations to display current, live data. Using Power BI to access large data sets without DirectQuery is impractical, because you cannot restrict results in such a way to avoid large and slow data downloads. DirectQuery ensures you retrieve only the data that is relevant to your needs.

DirectQuery is intended as a means of connecting live to large data assets and using that data without downloading large data sets. While many of your data assets may support DirectQuery from Power BI, there may also be other critical data assets that don't. For example, DirectQuery supports large Cloud-based data assets such as Amazon Redshift, Google BigQuery, IBM Netezza, SAP HANA and Snowflake, but not SAP Datasphere. If you connect Power BI to Datasphere directly using OData or ODBC, DirectQuery is not available. See a complete list of data sources supported by Power BI DirectQuery


Enable Ad Hoc Data Modelling

Enable power users to access ad hoc data preparation in order to contribute data models that can be used by other users. The interactive, easy to use interface allows for rapid creation of data models

Data Preparation Layer

Utilize the Data Preparation Layer

Allow administrators to define which data is available to Microsoft Power BI users translating the structures available in SAP Datasphere, so it's easily consumed by Power BI


APOS Administrator DetailsAPOS Administrator Sales InquiryAPOS Administrator Free Trial




Thought Leadership


MIND THE GAP: Expanding Data Access Options to Open SAP Analytics Opportunities

Expand and transform data connectivity to include all pertinent data sources in your Analytics.

View now

Unlocking the Value of Data with APOS Live Data Gateway
Futurum Research

Leveraging data is an imperative, but we also know that it has its challenges, such as managing data from disparate sources.

View now

Leveraging Data Connection Gateways to Harness Full Value from Analytics Investments
SAPinsider Research
Market Insight

SAPinsider's Kumar Singh describes the critical role of analytics in digital transformation.

View now

Expand, simplify and unify your data connectivity

94% of organizations need access to multiple data sources to support effective decision-making. Virtualized data connectivity is a timely, exciting solution.

View now

Performance with Large Data Sets

In today's data landscapes it is critical that there is strong processing performance for large and growing data environments including Cloud and Big Data platforms. Live Data Gateway has been designed to thrive with such scenarios. See how the APOS Live Data Gateway performs with large data sets in Snowflake (288 billion rows - 10TB data set) and Google BigQuery (196 million rows)

Extensive Data Source Support


APOS Live Data Gateway Power BI extension connects Power BI to APOS Live Data Gateway, which connects to a wide and diverse range of data assets via ODBC, OData and JDBC, including SAP Datasphere, and enables use of DirectQuery. Access to data is fast and efficient.

APOS Live Data Gateway enables live connectivity between Power BI and a wide variety of data assets using DirectQuery, making DirectQuery available for all of the 150+ relational, OLAP, Hadoop and Cloud sources it supports. See a complete list of data sources supported by APOS Live Data Gateway

Extensive data source support


WR Grace

This APOS solution was extremely easy to deploy, simplifying the process of connecting to Google BigQuery and our other data sources. We were also pleased with live data connecting using the APOS Live Data Gateway because it kept all data within the corporate firewall for an added level of security.

Sunil Kumar, SAP Enterprise Architect, WR Grace

WR Grace

WR Grace Success Story with APOS Live Data Gateway for SAP Analytics Cloud

W.R. Grace established direct data connectivity in live mode to Oracle, SQL Server and Google BigQuery for more informed analytics - Read more


Europe-Based Retail Chains Success Story with APOS Live Data Gateway for SAP Analytics Cloud

Live data access to Snowflake Data Cloud from SAP Analytics Cloud
Read more

Aspris Success Story with APOS Live Data Gateway

Live data connectivity from SAP Analytics Cloud to Azure SQL
Read more

Multinational Construction Equipment Manufacturer Success Story with APOS Live Data Gateway

Live Connectivity to Microsoft SQL Server, Google Analytics, Salesforce data
Read more

Specialty Mineral Leader Success Story with APOS Live Data Gateway

Live data connectivity and drill-down capabilities for their Amazon Redshift Cloud data warehouse to consolidate financial and billing data Read more


See our case studies and customer stories


APOS Administrator DetailsAPOS Administrator Sales InquiryAPOS Administrator Free Trial


You are in good company

Some of the hundreds of organizations using APOS well managed BI solutions across the globe:

University of Pittsburgh Medical CenterAPOS Live Data GatewayEnergy NorthwestAPOS Live Data GatewaySalling GroupAPOS Live Data GatewayBlue Cross Blue Shield Kansas CityAPOS Live Data GatewayHarvey NormanAPOS Live Data GatewayUniversity of Miami