The time has come: in 2026, 𝘂𝘀𝗶𝗻𝗴 𝗔𝗜 𝘁𝗼 𝘄𝗿𝗶𝘁𝗲 𝗗𝗔𝗫 𝗵𝗮𝘀 𝘀𝘁𝗮𝗿𝘁𝗲𝗱 𝘁𝗼 𝗯𝗲 𝗲𝗳𝗳𝗲𝗰𝘁𝗶𝘃𝗲. We also created three new video courses that should not become obsolete in two weeks! 𝗔𝗜 𝗳𝗼𝗿 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜: 𝗜𝗻𝘁𝗿𝗼 (𝗳𝗿𝗲𝗲!) 𝗗𝗔𝗫 𝘄𝗶𝘁𝗵 𝗔𝗜: 𝗘𝘀𝘀𝗲𝗻𝘁𝗶𝗮𝗹𝘀 𝗗𝗔𝗫 𝘄𝗶𝘁𝗵 𝗔𝗜: 𝗦𝗰𝗲𝗻𝗮𝗿𝗶𝗼𝘀 We have a page dedicated to AI for Power BI and DAX, where you can also find the link to these courses: sqlbi.com/ai/?aff=twitter I wrote a long post to recap what has changed between 2023 and 2026, and trying to answer many questions I expect to receive: sqlbi.com/blog/marco/2026/09… I am looking forward to receiving all types of comments! 🙂

Microsoft is retiring its Whiteboard app on September 14. Here is what we drew instead: free, open source, and native to Windows 11.

Hints from a book from the future: “Honestly, it would be better to be a good data modeler and a mediocre DAX author than a DAX guru but a poor data modeler. Therefore, if data modeling is not your cup of tea, roll up your sleeves and start learning it. Maybe during the pauses, while reading this book: you will attain two great goals at once.”

The 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝗗𝗔𝗫 book (aka 𝗧𝗵𝗲 𝗕𝗿𝗶𝗰𝗸, as it is 800+ pages) is now 𝗮𝘃𝗮𝗶𝗹𝗮𝗯𝗹𝗲: - Paperback (Black & White) - Hardcover (Color) - eBook (PDF, Kindle, ePub) 𝗥𝗲𝗮𝗱 𝗺𝗼𝗿𝗲: sqlbi.com/articles/the-optim… 𝗢𝗿𝗱𝗲𝗿 𝗼𝗻𝗹𝗶𝗻𝗲: sqlbi.com/books/optimizing-d…

𝗗𝗶𝗿𝗲𝗰𝘁 𝗟𝗮𝗸𝗲 𝘃𝘀. 𝗜𝗺𝗽𝗼𝗿𝘁 𝗺𝗼𝗱𝗲 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 What is the right choice between Direct Lake and Import mode in Power BI? #powerbi #vertipaq #directlake #import sqlbi.com/blog/marco/2024/04…

The 𝘃𝗶𝘀𝘂𝗮𝗹 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻𝘀 in #powerbi introduced a new concept: the 𝘃𝗶𝘀𝘂𝗮𝗹 𝗰𝗼𝗻𝘁𝗲𝘅𝘁. This article+video introduces EXPAND and COLLAPSE, two functions to navigate the visual context. #powerbi #visualcalcs sqlbi.com/articles/introduci…

I will speak at SqlBits 2024 in Farnborough and at the Microsoft Fabric Community Conference in Las Vegas! #sqlbits #fabricconf

I am glad to announce that @kurtbuhler has started to work with us at SQLBI. The video describes the most difficult part of the job. 😎 Read more: sqlbi.com/blog/marco/2024/03…

This article+video from @kurtbuhler describes the different approaches to format your #dax measures in #powerbi semantic models using format custom and dynamic format strings. sqlbi.com/articles/improving…

Short, sad story. Once upon a time, there was a 𝙡𝙖𝙯𝙮 data modeler. Their semantic model did not work. End of the story. Credits: @FerrariAlberto #powerbi #datamodeling

This article+video shows how to compute ratios when row-level security hides some of the data, and you need a percentage that includes the hidden rows in the comparison. #powerbi #dax sqlbi.com/articles/computing…

The DirectQuery over SQL section of the Optimizing DAX video course is now available! More than five additional hours of lectures, assuming you know how to optimize SQL afterward. #dax #optimizingdax #powerbi Read more: sqlbi.com/blog/marco/2023/11…