View this newsletter in your browser


Measuring the dictionary size of a column correctly

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular. Read more »


Smart Filter update (v1.1.6) for Power BI

In the latest update of Smart Filter we fixed an annoying issue with Internet Explorer 11 and introduce a new cool feature - now you can bind multiple columns to the visual to have nested filters sharing the same space!

Smart Filter by OKViz

This new version will be availble in the Office Store in a few days, but you can try the BETA just now. Download it now »


Learn DAX in Canada

Don't miss our next classes in Vancouver and get the Early Bird discount:

CanadaMastering DAX (Oct 2-4, 2017)
Optimizing DAX (Oct 5-6, 2017)


Power BI resources, SSAS and SSDT updates

• Power BI and PowerApps integration
The integration between Power BI and PowerApps is moving forward. You can embed Power App in a Power BI dashboard (but not in a report), and now you can also host a Power BI tile in PowerApp. There is a long road ahead for a full integration, these should be just the first steps. Read more »
 • Restricting external users from Power BI Premium resources
Adam Saxton published a good video explaining how to restrict external users from using your Power BI Premium resources. Even if you do not have such version, it is interesting to understand the level of control available in the Premium offer. Watch now »
• SQL Server Analysis Services 2017 RC2
Analysis Services 2017 is almost ready. Microsoft released the RC2 of SQL Server 2017 but there are no new features, only bug fixes. Read more »
 • SQL Server Data Tools update
The latest update of SQL Server Data Tools (SSDT) includes the editor for the object level security in compatibility level 1400. From hereinafter, if you want the latest updates sooner you should consider moving to Visual Studio 2017. The editor for Analysis Services is updated more often there than SSDT for Visual Studio 2015, which requires a separate installer. However, both versions are aligned today. Read more »
 • Azure Analysis Services Web Designer update
Azure Analysis Services has a web-based designer that today has just a fraction of the features available in Visual Studio. It has been updated a few days ago, and the new features include a syntax highlighter. Read more »