I am proud to announce the second version of the Contoso Data Generator! In January 2022, we released the first version of an open-source project to create a sample relational database for semantic models in Power BI and Analysis Services.…  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

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