SQLBI Newsletter #254

NEW ARTICLE

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

NEW TOOL

DAX Optimizer public preview

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.

#254 · Oct 2023

LEARNING

Course calendar

Mastering DAX

	Nov 1-3 - Palo Alto
	Nov 6-8 - Atlanta
	Dec 5-7 - Cologne

Data Modeling

	Nov 7-9 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	DAX Patterns

BI-WEEKLY NEWS DIGEST

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

SQLBI YOUTUBE CHANNEL