Marco Russo's Blog
View full profileThe second edition of Optimizing DAX is complete
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
Direct Lake vs. Import mode in Power BI
What is the right choice between Direct Lake and Import mode in Power BI? Read more
When the new thing is not new but still good
We did it again! Yesterday, as an April Fool, we published an article written by ChatGPT-4 (Revolutionizing Power BI: Introducing the Ultimate Formula Language), which described better than I could have ever done the excitement for a new revolutionizing language:… Read more
Vpax-Obfuscator: a library to obfuscate VPAX files
Last week, we released the first open-source library to obfuscate VPAX files: the Vpax-Obfuscator, also available as a NuGet package and as a command line tool (CLI). Read more
Compatibility levels and engine supported by Power BI Desktop
If you use Power BI Desktop and want to know the version of the engine that you use and/or the compatibility levels supported, you can run the following DMV query: SELECT * FROM $SYSTEM.DISCOVER_PROPERTIES WHERE [PropertyName] = ‘ProviderVersion’ OR [PropertyName]… Read more
Welcome, Kurt Buhler!
I am glad to announce that Kurt Buhler has started to work with us at SQLBI – we just published his first article and video, Improving data labels with format strings. Now that the cat is out of the bag,… Read more
Where are Visual Calculations and DirectLake?
The right title for this blog post should be “Guidelines for SQLBI content publishing”, but it would be too boring. And, at the time of writing, the more common questions we receive about articles that are nowhere to be found… Read more
Announcing SQLBI Days: more options to improve your DAX knowledge!
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
What happened in the DAX world in 2023
Our end-of-the-year tradition is to recap what happened in the DAX and SQLBI world and look at what is coming next. Read more
New DirectQuery modules in the Optimizing DAX video course
The DirectQuery over SQL section of the Optimizing DAX video course is now available! In May 2023, we released the second edition of Optimizing DAX, which was completed for the first three sections: Core Concepts, Formula Engine, and VertiPaq. The… Read more