SQLBI Newsletter #261

NEW ARTICLE

Differences between DATEADD and PARALLELPERIOD in DAX

This article describes the differences between the results of DATEADD and PARALLELPERIOD in DAX. These differences also impact many other time intelligence functions that are syntax sugar of these two.
Read more

#261 · Jan 2024

LEARNING

Course calendar

Mastering DAX

	Feb 27-29 - Dallas
	Mar 4-6 - Amsterdam
	Apr 15-17 - New York City
	May 6-8 - Seattle
	May 14-16 - Hamburg
	May 22-24 - Copenhagen
	Jun 25-27 - Chicago

Data Modeling

	Jul 2-4 - 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

CLASSROOM COURSES

Mastering DAX in Europe

You have three options to attend a Mastering DAX classroom course in Europe before June. Marco or Alberto will be present as your speaker.
Do not wait to register, seats are limited!

Full course schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• Dynamic subscriptions for Power BI reports You can create a subscription to a Power BI report with dynamic parameters, for example to send a custom report to each user. There are limitations and the feature is in preview, but it is a game changer for many use cases. Jan 16, 2024 · Microsoft
	• New limits for the “Maximum Connections Per Data Source” property in Power BI DirectQuery mode When you publish a report in DirectQuery, there is a limit to the number of concurrent queries running on the data source. This limit can impact the performance and scalability of a report, but it also protects the data source from overload. You can change the limit, but up to a certain level (which has been increased), depending on the capacity. Yes, the Power BI capacity. Jan 21, 2024 · Chris Webb
	• Power BI Report Server January 2024 updates This update to Power BI Report Server only contains news on the visualization side, no news for the other areas. But the update could be important for your reports, so check it out. Jan 26, 2024 · Microsoft
	• On-premises data gateway December 2023 release Regular call to action: update your data gateway if you have one - like the majority of Power BI users. Dec 30, 2023 · Microsoft
	• Tabular Editor 2.22.0 The latest version of Tabular Editor 2 supports the latest updates to TMDL serialization (Tabular Model Definition Language), and new TOM properties. Jan 19, 2024 · Daniel Otykier

SQLBI YOUTUBE CHANNEL