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
-
Explore how you can hide columns and tables to Power BI users by using the Object Level Security (OLS) feature released in February 2021. By hiding objects, you also hide derived calculations like measures, calculated columns, and calculated tables. The… Watch now
-
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
-
What are the differences between Power BI Desktop, Visual Studio, and Tabular Editor as modeling tools? Introducing the workspace is important to understand why Tabular Editor results in being more flexible and productive. Watch now
-
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
