SQLBI Newsletter #194

UPDATED ARTICLE

Optimizing conditions involving blank values in DAX

This updated article (now including a video) describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases.
Read more

#194 · Jul 2021

LEARNING

Course calendar

video courses

DAX PATTERNS

Transition matrix

The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals. For example, customers might receive a rating evaluation every month. Measuring the changes in rating between two points in time might require the evaluation of how many customers moved from one rating to another within the considered interval. The transition matrix enables the end-user to make this kind of analysis by just manipulating filters in a report and without having to write any custom query.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Power BI June 2021 Update The big news in the June 2021 update of Power BI is the preview of the paginated report visual. There are many other improvements; dataflows are now included in deployment pipelines. All the details in the official announcement. Jun 25, 2021 · Microsoft
	• What’s new in the June update of Power BI Report Builder You can now download Power BI Report Builder from the Microsoft Store. Automatic updates, no admin permissions required. You no longer have any excuse to delay practicing on paginated reports. Jun 2, 2021 · Microsoft
	• Scanner API enhancements in Power BI Admin REST APIs You can write scripts and create programs that retrieve metadata from large Power BI tenants. You can retrieve measure names within a dataset schema without having to open a connection with the dataset itself. And it also works on non-Premium workspaces. Jun 28, 2021 · Microsoft
	• Choosing Azure Analysis Services or Power BI Premium for large datasets Power BI Premium now processes large models with a segment size of 8 million rows, instead of the default 1 million rows. There are now very few differences between Azure Analysis Services and Power BI Premium. An updated recap in this short blog post. Jun 29, 2021 · Marco Russo
	• Increasing refresh parallelism – and performance – in Power BI Premium The XMLA endpoint in Power BI Premium enables partition management, as well as the parallelization of the processing that you can customize by writing TMSL scripts. Nothing new really, if you know Analysis Services... But how many of you remember where to put the maxParallelism attribute? A very useful resource. Jul 27, 2021 · Chris Webb
	• DAX Studio 2.16.1 The latest release of DAX Studio comes with many improvements, including the preview of Debug Commas (see the unplugged video) and query builder enhancements. The article is about the 2.16 release, even though minor fixes were released shortly after. Jun 28, 2021 · Darren Gosbell
	• Migrating Power BI report-level measures to the model If you have many measures in a Power BI report connected live to a shared dataset and you would like to migrate them to the Tabular model, you now have a script that solves the problem. Jun 21, 2021 · Michael Kovalsky

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.