In this tutorial, you’ll learn how to use the VertiPaq Analyzer in DAX Studio to optimize your data model in Power BI. VertiPaq Analyzer is a built-in tool in DAX Studio that extracts meaningful information about tabular models from an optimization standpoint. To launch VertiPaq Analyzer, go to the Advanced tab in DAX Studio. Then,
In this tutorial, you’ll learn how the CROSSJOIN function works in DAX using the Server Timings pane and its query plan. The CROSSJOIN function can be used to create a Cartesian product of two tables. A Cartesian product is a set of all possible combinations of rows from two or more tables. The DAX code
Both CALCULATETABLE and FILTER are powerful tools for manipulating and analyzing data in DAX query, but they have some key differences that are important to understand. In this blog, we’ll go over the CALCULATETABLE function and its query plan in DAX studio, and understand how it differs from the FILTER function. By the end, you’ll
In this tutorial, you’ll learn how to load the results of a dynamic management view (DMV) using a prebuilt template in Power BI. This template is created by Brett Powell from Insight Quest. You can download the file from the GitHub repository. Once the download is finished, open the file. You need to input the
In this tutorial, you’ll learn about Dynamic Management Views (DMV) in DAX Studio and how to use them to directly load datasets in Power BI. A Dynamic Management View or DMV returns server information which you can use to monitor the health of a Power BI server and diagnose any problems that may occur. This
