Microsoft Ignite and PASS Summit

In the second half of the year we will deliver sessions and preconference days in two big events. See more below:

	Microsoft Ignite 2017 Sep 25-29, 2017 – Orlando, FL
	PASS Summit 2017 Oct 30 - Nov 3, 2017 – Seattle, WA

Last courses of the year in US

Don't miss our last courses of 2017 in US. Only one last course for Optimizing DAX and Analysis Services Tabular, and three options for Mastering DAX:

	Dallas • Oct 23-25 - Mastering DAX • Oct 26-27 - Optimizing DAX
	New York • Nov 6-7 - SSAS Tabular • Nov 8-10 - Mastering DAX
	Seattle • Dec 4-5 - SSAS Tabular • Dec 6-10 - Mastering DAX

Power BI update, data refresh and more...

	• Power BI Desktop September update Microsoft is going to release a new version of Power BI Desktop (September 2017), which will probably introduce the Drillthrough Action announced at the Data Insight Summit in June (the feature is already available online). This is a huge improvement in data navigation. Bookmarks are not here yet, they will probably arrive in October. Watch out on Power BI blog »
	• Power BI Report Server preview Power BI Report Server has a new preview released in August 2017. You need a specific version of Power BI Desktop included in the package to create reports, which you can connect to any data source now. Scheduled data refresh and Direct Query are still not available here, but they will be included before the GA version. Read more »
	• Local DAX measures in Power BI not visible from Excel The ability to select a data model by choosing a report seems like a way to get the semantic model from the report (including the local measures) rather than just a shortcut to pick the corresponding dataset. Read more »
	• Power Apps and Power Query Power Query now supports (in preview) getting data from the Common Data Service. Microsoft is doing a long-term investment on this technology, which integrates PowerApps and possibly many other services in the future. Pay attention to future developments. Read more »
	• Refresh Power BI datasets with Azure Runbook A good example of how to implement the API for refreshing a Power BI dataset using an Azure Automation Runbook is now available in the Gerhard Brueckl blog. This is what you need to create a complex refresh logic completely cloud-based. Read more »
	• Automation of Azure Analysis Services Data refresh can be also automated in Azure Analysis Services, and Christian Wade does a good job of explaining how to better control security using Service Principals and PowerShell to run this task. Read more »
	• Using Visual Studio Configurations in SSAS Using Visual Studio configurations in Analysis Services projects is useful to differentiate deployments between test and production environments. The UI is not intuitive and Koen Verbeeck does a good job of explaining the trick to make it work. Read more »