New article: Reading active Power BI security roles in DAX
This article describes how to read the active security roles in a Tabular model for Power BI or Analysis Services. This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for the current user.
Read more


We released a new video course and whitepaper on SQLBI+: Inside Calculation Groups is available! A deep dive into calculation groups in DAX that includes best practices and a rich set of examples.
Read more
SQLBI+ Inside Calculation Groups

Over the last few years, we have been working in "stealth mode" on a new tool: DAX Optimizer. You can join the waitlist for the beta program or wait a few months for the general availability and the announcement fireworks!
Read more


Latest news
• DAX Studio 3.0.8 release
The latest version of DAX Studio has a large number of bug fixes, plus the support of dynamic format strings in Define Measure and improvements to the metadata refresh for Fabric Direct Lake models.
Jun 14, 2023 · DAX Studio
• The “Visual has exceeded the available resources” error in Power BI Desktop
You can simulate the query limits of Power BI service in Power BI Desktop, to diagnose potential issues in reports that consume too much memory or CPU.
Jun 18, 2023 · Chris Webb
• On-premises data gateway June 2023 release
It is time to update your data gateway. Mandatory update to support Lakehouse connectivity (Fabric, of course).
Jun 21, 2023 · Microsoft
• On-demand loading of Direct Lake Power BI datasets in Fabric
How to analyze in DAX Studio the dynamic loading of columns from a dataset based on Direct Lake in Fabric. We start to discover the innovations that Direct Lake in Fabric brings to Power BI.
Jul 2, 2023 · Chris Webb
• Bravo for Power BI 1.0.4
Important bug fixes in the latest version of Bravo for Power BI.
Jun 11, 2023 · SQLBI

Latest videos
Introducing RANK window function in DAX
15:24#articleAlberto Ferrari
The Making of Optimizing DAX Second Edition - Unplugged #53
24:29#unpluggedAlberto Ferrari & Marco Russo