Get full access to Microsoft Power BI Quick Start Guide and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

Limitations

So, if DirectQuery is so great, why not choose it every time? Well, with every great feature you will also find limitations. The first glaring limitation is that not all data sources support DirectQuery. As of the time this book was written, the following data sources support DirectQuery in Power BI:

Amazon Redshift
Azure HDInsight Spark
Azure SQL Database
Azure SQL Data Warehouse
Google BigQuery
IBM Netezza
Impala (Version 2.x)
Oracle Database (Version 12 and above)
SAP Business Warehouse Application Server
SAP Business Warehouse Message Server
SAP HANA
Snowflake
Spark (Version 0.9 and above)
SQL Server
Teradata Database
Vertica

Depending on the data source you choose, there is a chance of slower query performance when ...

Get Microsoft Power BI Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Get it now

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

Start your free trial Become a member now