View this newsletter in your browser


Storage differences between calculated columns and calculated tables

This article compares the differences between calculated columns and calculated tables from a processing and storage point of view.
Read more »


New releases of OKViz custom visuals

We just released some new versions of our free custom visuals with bug fixes and nifty additions. See the change log and try them:

Please note that these versions are in BETA. In the next weeks they will be published in the Office Store and automatically updated in all the reports that use them.

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:

• Oct 23-25 - Mastering DAX
• Oct 26-27 - Optimizing DAX
New York
• Nov 6-7 - SSAS Tabular
• Nov 8-10 - Mastering DAX
• 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 »