SQLBI Newsletter #204

NEW ARTICLE

Analyzing the parallelism of storage engine operations in DAX Studio

This article describes the improved Server Timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations and the dependencies between Scan and Batch requests.
Read more

#204 · Nov 2021

LEARNING

Course calendar

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
	Power Pivot

DAX PATTERNS

Comparing different time periods

This pattern is a useful technique to compare the value of a measure in different time periods. For example, we can compare the sales of the last month against a user-defined period. The two time periods might have a different number of days, like comparing one month against a full year. When the durations of both time periods are different, we should adjust the values to make a fair comparison.
Read more

ANNOUNCEMENT

Black Friday 2021

The best shopping day of the year is around the corner. Don't miss our special discounts by visiting the SQLBI website on Nov 26, 2021!

SQLBI YOUTUBE CHANNEL

Latest news

	• DAX Studio 2.17 The main article in this newsletter is about the features released in the new DAX Studio version. As usual, you should upgrade. In the meantime, more significant work is ongoing for version 3.0. Stay tuned. Nov 15, 2021 · Darren Gosbell
	• Power BI November 2021 Update The November release of Power BI has many news for the report designer: new format pane, page and bookmark navigators, scorecard visuals, and other improvements. There are also new and updated connectors for Google Sheets and Google BigQuery. Nov 15, 2021 · Microsoft
	• New format pane in Power BI The new format pane in Power BI Desktop is in preview and must be enabled in the preview options. The feature is promising, but not ready for production. Invest some time in testing it and provide feedback to Microsoft. We have seen complaints about missing features and reduced productivity for certain operations, but overall the direction is correct. Nov 15, 2021 · Microsoft
	• Power BI XMLA endpoints support EffectiveUserName You can now impersonate users by using EffectiveUserName in the connection string to an XMLA endpoint in Power BI Premium. This is a feature that has always been available in Analysis Services (both on premises and on Azure), and it was a reason that prevented the migration to Power BI. Nov 18, 2021 · Microsoft
	• Capacity settings for datasets are now in Power BI Premium Gen2 Another feature that is import to enable migration from Analysis Services: you can now control settings such as MaxIntermediateRowsetSize, which is called Max Intermediate Row Count in Power BI capacity settings. This is important for DirectQuery. Only available in Power BI Premium Capacity, not in Power BI Premium Per User. Nov 18, 2021 · Microsoft
	• Power BI/Power Query data privacy settings and errors caused by nested values Data privacy settings are a small nightmare when dealing with Power Query. This article covers another one of the mysterious errors you might encounter because of them. Nov 14, 2021 · Chris Webb
	• Loading large random datasets with Power Query If you need to create large random datasets, now you have a working example for Power Query. Definitely a low code solution. Nov 7, 2021 · Sergio Murru

View Web Version · Status & 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.