View this newsletter in your browser


Controlling drillthrough using Detail Rows Expressions in DAX

The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property.
Read more »


Latest news from PASS Summit 2017

Marco Russo describes and comments the latest news announced at the keynote of PASS Summit 2017. Read more »

PASS Summit 2017

Last seats for New York and London

London’s course was sold-out but we found a larger classroom.
Don’t wait the last minute and register now to get the last seats available in New York and London!

New York
• Nov 6-7 - SSAS Tabular
• Nov 8-10 - Mastering DAX
• Nov 27-29 - Mastering DAX
• Nov 30/Dec 1 - Optimizing DAX


SQL Server update and Power BI Q&A

• Cumulative Update 1 for SQL Server 2017
The Cumulative Update 1 for SQL Server 2017 is now available. Please be aware that Cumulative Updates are the new Service Packs, so you should install them. There are several fixes for Analysis Services too. There is only one issue: the build number you will see in SQL Server Management Studio connecting to Analysis Services is the same ( for both SSAS 2017 RTM and SSAS 2017 CU1. It’s a minor bug for us, a major headache for Microsoft support, which will need the file version number to understand the exact build running. Clearly this will be fixed in the next Cumulative Update. Read more »
• Embed Power BI Q&A in your application
Adam Saxton shows in a video how to embed Power BI Q&A in your application using JavaScript. The sample code is available. Watch now »
 • PASS Summit 2017 FREE live-streaming
Watch live sessions from the biggest conference about the Microsoft Data Platform currently running in Seattle. Watch now »