Topic: Optimization
-
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
-
I am glad to be back in Australia in August 2024: we planned three Mastering DAX classes and two SQLBI Days about DAX Optimization. Read more
-
We are proud to announce the availability of our new book, Optimizing DAX. Read more
-
Almost a year ago, we announced the release of three sections (core concepts, formula engine, and VertiPaq); in November 2023, we released the DirectQuery over SQL section; now, in April 2024, we release the last section of Optimizing DAX about… Read more
-
Learn how to use the new Vpax obfuscator to send anonymized VPAX files to DAX Optimizer. Read more: https://www.tabulartools.com/blog/supporting-obfuscation-in-dax-optimizer/ Disclaimer of a potential conflict of interest: Marco Russo is one of the authors of DAX Optimizer and a founder of… Watch now
-
This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. Read more
-
At SQLBI, Alberto Ferrari and I spend most of our time sharing our knowledge and expertise in DAX. We have been doing this for years, navigating through conferences, workshops, and videos, encountering many individuals – from eager beginners to seasoned… Read more
-
This article explains a typical pattern to optimize a SUMX iterator by reducing the number of callbacks in the expression. Read more
