New article: Optimizing callbacks in a SUMX iterator
This article explains a typical pattern to optimize a SUMX iterator by reducing the number of callbacks in the expression.
Read more



Four months ago, DAX Optimizer started being available in private preview.
The tool that helps you find and fix bottlenecks in your DAX code is now publicly available and still in preview. Additional features are coming soon, and in the meantime you can enjoy the preview discounts, or just use the samples available for free when you login.

Read more


Latest news
• Bravo for Power BI 1.0.6
While Bravo for Power BI has not had any new features in the last few months, we continue to provide updates to fix bugs and get the latest connection libraries. Do not miss this latest update!
Oct 20, 2023 · SQLBI
• Power BI October 2023 updates
Big updates in October: the new model explorer available in the diagram view introduced the calculation group authoring, which is a separate piece of news. Several other updates, in particular for on-object interaction and integration to OneDrive and SharePoint.
Oct 11, 2023 · Microsoft
• Calculation groups authoring in Power BI Desktop
More than three years after Power BI Desktop started supporting calculation groups (July 2020), it is now finally possible to create and edit calculation groups in Power BI Desktop without relying on an external tool like Tabular Editor. Someone said that the "P" in Power BI stands for Patience.
Oct 16, 2023 · Microsoft
• On-premises data gateway October 2023 release
Besides the monthly updates, pay attention to the library upgrade required if you use the gateway with the SAP ERP connector.
Oct 19, 2023 · Microsoft
• How to use Tableau with Power BI and Fabric
If you use both Tableau and Power BI, you can get the best of both worlds. Like creating a report connected to multiple datasets without creating a composite model.
Oct 17, 2023 · Kurt Buhler
• What does it mean to refresh a Direct Lake Power BI dataset in Fabric?
By default, a model in Direct Lake refreshes automatically, but you might want to control the process to avoid exposing inconsistent numbers during data preparation.
Oct 8, 2023 · Chris Webb
• Troubleshooting automatic aggregations to optimize DirectQuery performance
DirectQuery optimization is a process that can require creating aggregation and maintaining them. Automatic aggregations can be helpful, but you still have to manage them. You will never have a boring day like those poor modelers who import data in memory.
Oct 9, 2023 · Microsoft
• Case-sensitive models in Power BI: consequences & considerations
We are used to thinking that Power BI and DAX are not case sensitive. But the reality is different, and there is a way to obtain case-sensitive models by leveraging the model Collation property.
Oct 18, 2023 · Kurt Buhler

Latest videos