Topic: Power BI
-
This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is clear: a star schema is always the best choice. Read more
-
This short article explains how to change the culture settings of a Power BI Desktop file, which by default corresponds to the locale settings of the machine used to create a Power BI Desktop file. Read more
-
This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic. Read more
-
This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries. Read more
-
This article explains how to avoid circular dependency errors that can occur in DAX when two or more entities (calculated columns or calculated tables) reference one another in such a way that the engine cannot compute their value. Read more
-
This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report. Read more
-
This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. Read more
-
Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views. Read more
-
When you apply a multiple selection to a slicer or to a filter, you obtain a logical OR condition between selected items. This article shows how to implement a logical AND condition in a measure instead of the standard OR… Read more
-
You can create static tables in DAX using the DATATABLE function. This article describes the syntax of this new feature and shows when and how to use it. Read more