New article: Managing hierarchical organizations in Power BI security roles
This article describes how to apply dynamic security roles in a hierarchical organization to minimize the maintenance effort on the security configuration and obtain the best performance at query time.
Read more


Did you notice that we have reached newsletter # 250? A newsletter every two weeks, you can do the math. We don't have time, let's look ahead...
Newsletter Archive

The pricing model of DAX Optimizer is now available. We are offering discounts during the beta/preview phase. Read this blog post for details!
Many people on the waitlist have already received an invitation, but the list is very long - do not worry, we will invite everyone on the list!
Read more


Latest news
• Excel tables in Power BI - the most important news this month
It was hard to find a good title to relate how important and long-awaited this feature is. If you have created a PivotTable in Excel connected to a Power BI dataset, you know that you could wait for ages when you have many columns - plus, the result is a long and wide table that you need for whatever reason. The PivotTable is designed for aggregated reports with few grouping columns. The new feature creates a DAX query that populates a table, something we have shown for many years in articles and videos, but it is now available out of the box in Excel. We know companies that have been asking for this feature since 2012/2013... The P in Power BI stands for Patience!
Aug 23, 2023 · Microsoft
• DAX Studio 3.0.10
The new indent based code folding feature is in preview, plus many fixes and updated libraries to guarantee full compatibility of the VPAX files produced for DAX Optimizer.
Aug 16, 2023 · Darren Gosbell
• Power BI August 2023 updates
New features, updates to the ORDERBY function, other improvements and updates. Come on, now we all want to use Excel, we can look for Power BI in September.
Aug 22, 2023 · Microsoft
• Automatic scaling for dataset scale-out public preview
This is probably the latest feature needed to bridge the feature gap between Azure Analysis Services and Power BI. Now the difference is just the licensing model. Depending on your needs, Azure Analysis Services might still make sense - or not.
Aug 22, 2023 · Microsoft
• Dynamic subscriptions for paginated reports
Talking about feature parity, whoever used SQL Server Reporting Services on-premises was certainly waiting for dynamic subscriptions in paginated reports. Not sure the user experience is what you want (no custom queries), but you can always create a calculated table to do the job.
Aug 21, 2023 · Microsoft
• Improving the communication performance of XMLA-based tools
This is news for nerds. How can a protocol change affect your life as a business user? Well, you have less time to sip your coffee! This is important news for users of external tools like DAX Studio and Tabular Editor.
Aug 23, 2023 · Microsoft
• Composite models in Power BI and Fabric
Composite models make a lot of sense to incorporate a small set of data (e.g. a forecast) into an existing large dataset. Guidance is needed to avoid misusing features, but what is good for Fabric can be also applied to your forecast in Excel.
Aug 18, 2023 · Kurt Buhler
• Can you develop for Power BI using only your browser?
No. But you can read a more politically correct description here. (We should say "not yet", but we like to be direct over here.)
Aug 13, 2023 · Chris Webb

Latest videos
Differences between GROUPBY and SUMMARIZE
28:30#articleAlberto Ferrari
The Making of Optimizing DAX Second Edition - Unplugged #53
24:29#unpluggedAlberto Ferrari & Marco Russo