We recently surpassed the 100,000 subscribers milestone on the SQLBI YouTube channel. Therefore, Alberto and I unboxed the plaque received by YouTube. We are still fighting for who should keep it! Thank you all for watching us.  Read more

In 2023, we released the first draft of the Window functions in DAX whitepaper as part of SQLBI+. Since then, we have released a few updates and are now glad to announce the availability of the related 3-hour video course…  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

DAX is not like M when it comes to data manipulation, and it is not supposed to do that. However, if you need something in DAX similar to Table.FromList in M, this blog post is for you. If you have…  Read more

Digital media content creators have an ethical responsibility to journalistic integrity. All of them do; all of us… including myself.  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

What is the right choice between Direct Lake and Import mode in Power BI?  Read more

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

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

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