Past Meetup

DirectQuery in Analysis Services: best practices, performance, use cases

This Meetup is past

42 people went

Location image of event venue


Speaker: Marco Russo, Business Intelligence consultant and mentor

DirectQuery is a feature of 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. This feature has been improved and optimized in the latest versions, including Azure Analysis Services, extending the support to relational databases other than SQL Server, and dramatically improving its performance.
In this session, you will learn what are the 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.

About Marco:
Marco Russo is a Business Intelligence consultant and mentor, specialized in Microsoft BI Technologies. He wrote several books about DAX, Analysis Services, Power BI, and Power Pivot, and regularly publish articles and tools on He is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, and SQLBits.