SQLBI Newsletter 16/2017

NEW ARTICLE

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 »

OKVIZ UPDATE

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!

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 »

COURSE HIGHLIGHT

Learn DAX in Canada

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

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

BI NEWS DIGEST

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 »