Topic: Optimization
-
Visual calculations can either improve or degrade the performance of a report. In this article, we outline how we ensure visual calculations have a positive impact on performance. Read more
-
Applying security roles to a Power BI model or to an SSAS Tabular database might impact query performance. This article describes existing issues and possible workarounds. This is an advanced article; a good knowledge of the storage engine and formula… Read more
-
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships. Read more
-
DAX Optimizer Basic is a new way to analyze the performance of your Power BI and Fabric semantic models for free, without installing anything and without paying upfront. Just copy the diagnostic query result, paste it into the web app,… Watch now
-
In this article, we examine the details of executing DAX code, with a focus on how the IF function is implemented in various scenarios. Read more
-
This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
-
Optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Watch now
-
Overview of the techniques and the tools (free and commercial) available to optimize the performance of DAX expressions in Power BI models. You learn what you can do with Performance Analyzer included in Power BI, how to extract query plans… Watch now
-
We released more content in SQLBI+ with two new sessions: Introducing Visual Calculations in Power BI: This two-hour session introduces the Visual Calculations feature in Power BI, which is still in preview. We plan to update the “Understanding Visual Calculations… Read more
-
Did you ever want to extract a VPAX file using a command line tool? If you are among the early adopters of DataOps principles or simply want to automate processes, you will be glad to know that we now have… Read more
