DirectQuery

WHITEPAPER

DirectQuery in Analysis Services 2016

Summary: DirectQuery transforms the Microsoft SQL Server Analysis Services Tabular model into a metadata layer on top of an external database. For SQL Server 2016, DirectQuery was redesigned for dramatically improved speed and performance, however, it is also now more complex to understand and implement. There are many tradeoffs to

ARTICLE

Analyze DirectQuery requests using DAX Studio

This article describes how DAX Studio can analyze the SQL queries sent to a relational database by Power BI or Analysis Services Tabular in DirectQuery mode.

ARTICLE

Tuning query limits for DirectQuery

This article describes a few query limits existing in DirectQuery for both Power BI and Analysis Services Tabular 2016, explaining when you can modify them.