Review DirectQuery in SSAS 2016, best practices and use cases

Sign in to queue

Description

DirectQuery is a feature of Microsoft Analysis Services that transforms a Tabular model in a semantic layer on top of a relational database, transforming any MDX or DAX query in a real-time request to the underlying relational engine using the SQL language. In Analysis Services 2016 this feature has been improved and optimized, removing several limitations, extending the support to relational databases other than SQL Server, and dramatically improving its performance. Learn what are the new features of DirectQuery, how to implement best practices in order to obtain the best results, and what are typical use cases where DirectQuery should be considered as an alternative to the in-memory engine embedded in Analysis Services.

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents