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, we’re going to cover the difference on how data indexing works in a relational database versus in Vertipaq. Relational databases store the data on a row by row basis. On the other hand, Vertipaq does it column by column. Let’s see how these two ways of storing and indexing data could impact
In this tutorial, we’ll go through a quick overview of all the options available in the user interface of DAX Studio. These include the panes and each button in the ribbon. We’ll discuss how using these features will help improve your performance in DAX Studio. It’s important to familiarize yourself with the purpose and function
This tutorial will talk about optimizing your queries in DAX Studio. You’ll also learn how to mitigate the presence of the CallBackDataID if ever they appear in your calculations. This will help improve DAX’s performance in generating accurate data. If you recall from previous blog posts, CallBackDataID appears when the storage engine asks help from
This tutorial will discuss about materialization for data caches in DAX Studio. This post will show how it affects your calculation while generating results with your query. You’ll learn which materialization is better in order to maximize DAX’s performance. There are two ideas of materialization: Early Materialization and Late Materialization. Early Materialization Early Materialization is
