Last classes of the year

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

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

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:

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 »