View this newsletter in your browser


Filtering and comparing different time periods with Power BI

This article introduces a technique to filter and productively compare two time periods with Power BI. Read more »


DirectQuery in Analysis Services: Best practices, performance, use cases

DirectQuery is a feature of Analysis Services that transforms a Tabular model in a semantic layer on top of a relational database, transforming any MDX or DAX query in a real-time request to the underlying relational engine using the SQL language. Watch now »


Last classes of the year

This is the calendar of the last classroom courses in 2017:

– Optimizing DAX
Only two classes left to optimize DAX queries:
• Dallas - Oct 26-27
• London - Nov 30/Dec 1

– Mastering DAX
More places for our best seller course:
• Dallas - Oct 23-25
• New York - Nov 8-10
• London - Nov 27-29
• Seattle - Dec 6-8
• Stockholm - Dec 13-15

– SSAS Tabular
Just two cities available to learn Analysis Services:
• New York - Nov 6-7
• Seattle - Dec 4-5


Offline model editor experience for Power BI

Marco Russo describes how to edit a Power BI model using Tabular Editor, which is very productive for changes to multiple objects. Join us asking to Microsoft a better support for open source tools. Read more »


Subtitles for Optimizing DAX Video Course

Optimizing DAX Video Course Do you know that 20% of users activate subtitles? For this reason, we just made English subtitles available also for Optimizing DAX Video Course!

If you cannot attend a classroom, video recorded courses are a good option to access the same content and exercises. Take a look at our offer:

• DAX » Introducing DAX / Mastering DAX / Optimizing DAX
• Power BI » Power BI Dashboard Design
• Analysis Services » SSAS Tabular
• Power Pivot » Power Pivot Workshop


Power BI October update, DAX Studio, SSDT/SSMS, and more...

• Power BI Desktop October update released
The Power BI Desktop October update is available on Windows Store and as a standalone download. You can use the Windows Store version only if you have Windows 10, whereas you need to download and install it manually on earlier versions of Windows. The automatic update of Windows Store guarantees you always get the latest updates without worrying about running a setup again. Bookmarks are the most important new feature of this release, but there is more. Read more »
 • DAX Studio 2.7.1 available
The DAX Studio version released two weeks ago (2.7.0) is not able to connect to the Windows Store version of Power BI Desktop. There is now a small update (2.7.1) that adds the support to this connection type and fixes other minor bugs. Get it now »
 • Upgrade reports from Power BI to Azure Analysis Services
If you publish a Power BI model to Analysis Services, you automatically lose all the reports included in the same PBIX file. Instead of creating a new report from scratch, Gerhard Brueckl explains an unsupported way to change the connection of your existing reports so that they use the database published on Analysis Services. Microsoft should provide a supported technique to do the same. Read more »
 • Control Power BI using PowerShell
Alexander Holmeset published a two-part blog post explaining how to control a Power BI model using PowerShell. This is not just administration. You can create a model and push data in a new Power BI report. You do not need to call an API, you can push data by using a PowerShell script – and you get real-time updates of dashboards based on these data sources, for free. Read Part 1 / Part 2 »
• SSDT and SSMS 17.3 available
The new 17.3 version of SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) is available. Bug fixes and performance improvements for SSDT seem more important than new features in this case. One more reason to update SSDT quickly. However, not much news for Analysis Services developers in SSMS. Read more »
• Create partitions using M in Analysis Services 2017
Chris Webb wrote a step-by-step guide describing how to leverage M functions to create a partitioned table in Analysis Services. You can use this technique in Analysis Services Tabular 2017 and in Azure Analysis Services. Read more »