Analyzing the parallelism of storage engine operations in DAX Studio
Marco Russo & Alberto FerrariThis article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. Read more
How to enable the Single Value option in a Power BI slicer
This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. Read more
Nov 30-Dec 2 - Amsterdam
Mar 15-17 - New York City
May 11-13 - Sydney
Video Training
Introducing DAX Video CourseFree
Creating real-time dashboards in Power BI with push datasets
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. In this article we introduce the architecture of push datasets. Read more
Implementing real-time updates in Power BI using push datasets instead of DirectQuery
Marco RussoPush datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
DAX Patterns
Survey
The Survey pattern uses a data model to analyze correlations between different events related to the same entity such as customer answers to survey questions For example in healthcare organizations the Survey pattern can be used to analyze data about… More on DAX Patterns
SQLBI Corp.
DAX Patterns, Second Edition
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more