SQLBI Newsletter #270

NEW ARTICLE

Introducing the 3-30-300 rule for better reports

This article describes a simple approach that you can apply to improve your reports and dashboards.
Read more

SQLBI+ UPDATES

In 2023, we released the first draft of the "Window functions in DAX" whitepaper as part of SQLBI+. Since then, we have released a few updates and are now glad to announce the availability of the 3-hour video course covering the full whitepaper content.

#270 · Jun 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Jun 25-27 - Chicago
	Aug 6-8 - Melbourne
	Aug 12-14 - Sydney
	Aug 19-21 - Brisbane
	Sep 18-20 - Calgary
	Oct 14-16 - London
	Nov 19-21 - Amsterdam

DAX OPTIMIZATION - 1 DAY

	Aug 9 - Melbourne
	Aug 15 - Sydney

DATA MODELING - 3 DAYS

	Jul 2-4 - Amster
	Sep 23-25 - Vancouver
	Dec 10-12 - 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

NEW BLOG POST

Strings list to table in DAX

DAX is not like M when it comes to data manipulation, and it is not supposed to be. However, if you need something in DAX similar to Table.FromList in M, this blog post is for you.
Read more

COURSES IN AUSTRALIA AND UK

Courses, SQLBI Days in Australia and the UK

Marco will be in Australia in August 2024 and back to London in October 2024!

Melbourne - bundle available!
- Aug. 6-8: Mastering DAX
- Aug. 9: First Steps in DAX Optimization
Sydney - bundle available!
- Aug. 12-14: Mastering DAX
- Aug. 15: First Steps in DAX Optimization
Brisbane
- Aug. 19-21: Mastering DAX
London, UK
- Oct. 14-16: Mastering DAX

Hurry, seats are limited!
These are the only dates in Australia and the UK for 2024!
Overall schedule

Mastering DAX and SQLBI Days Australia 2024

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI May 2024 udpate The most important announcement is that DAX Query View, Model Explorer, and authoring calculation groups are now generally available in Power BI Desktop. We know many companies needed this step to use calculation groups! May 21, 2024 · Microsoft
	• Power BI Report Server May 2024 update Good news for those of you still keeping the service on-premises: you now have a new version available, even though you will always be jealous of the latest shiny features in Power BI Desktop and Service. May 30, 2024 · Microsoft
	• Write DAX in a semantic model Tips and helpful suggestions to improve the DAX code you write without being an expert. The article covers Power BI Desktop, Fabric, and external tools like Tabular Editor. There are different ways to improve your productivity in each of the many editors available. May 14, 2024 · Kurt Buhler
	• Diagnosing Power BI DirectQuery connection limit problems You can limit the number of concurrent DirectQuery connections to investigate issues that may happen in production when multiple users are using DirectQuery-based reports. Indeed, the number of multiple connections is limited by the service, depending on the capacity available. May 19, 2024 · Chris Webb
	• New Power BI Matrix layouts The Excel PivotTable is the gold standard for all the visualization options you can desire. The Power BI matrix is far behind in terms of flexibility, even though it is way faster than its counterpart in Excel. The new Matrix layouts are the first step to bridge the gap. May 10, 2024 · PBI Core Visuals
	• Power BI Studio v2.0 Power BI Studio is a free, open-source VSCode extension that connects to your Power BI tenant and navigates assets available - including semantic models - with an integration with External Tools in Power BI Desktop. May 28, 2024 · Gerhard Brueckl

SQLBI YOUTUBE CHANNEL