SQLBI Newsletter #143

NEW ARTICLE

Filter top 3 products for each category in Power BI

This article describes different techniques to display the first three products for each category in Power BI. It includes considerations on how to adapt the technique to different models and requirements. Read more »

NEW ARTICLE

Understanding the application of calculation items

This article explains how calculation items are applied to measure references, and it is the third part of a series dedicated to calculation groups in DAX. Read more »

#143 – July 2019

DATA MODELING

	Oct 30-Nov 1 - San Francisco
	Nov 26-28 - Amsterdam

MASTERING DAX

	Jul 30-Aug 1 - Sydney
	Aug 6-8 - Melbourne
	Aug 14-16 - Perth
	Sep 17-19 - Chicago
	Oct 1-3 - Amsterdam
	Oct 2-4 - Denver
	Oct 8-10 - Washington
	Oct 22-24 - Copenhagen
	Nov 12-14 - Toronto

VIDEO COURSES

	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX 2
	Optimizing DAX
	SSAS Tabular
	Power Pivot

COURSES HIGHLIGHT

Upcoming courses

• Mastering DAX courses coming soon:

Chicago, IL, US – Sep 17-19

Denver, CO, US – Oct 2-4

Washington, DC, US – Oct 8-10

Copenhagen, DK – Oct 22-24

Toronto, ON, CA – Nov 12-14

NEWS DIGEST

Latest news on BI

	• Power BI Desktop July 2019 Update The buzz of the new release of Power BI Desktop is all about customizable icon sets for table and matrix! But there are other important features like the new single installer and the general availability of aggregations for DirectQuery, now supporting RLS. Read more »
	• Sending refresh notifications to others This is holiday time in many countries and you might want to send Power BI refresh failure notifications to other users other than you. It is now possible to do this. Will this be enough to avoid phone calls during your holiday? Murphy's law would say no... Read more »
	• On-premises data gateway July 2019 As anticipated, the July 2019 version of the gateway requires .NET 4.7.2. This stops compatibility with older operating system and it might install a new version of .NET on your server. Be careful and this time read the documentation! Read more »
	• BISM Normalizer 4.0.1.1 Christian Wade announced the release of BISM Normalizer 4.0.1.1, which supports Visual Studio 2019. If you need a tool to compare two versions of a Tabular model, this is what you are looking for. Download now »

You are receiving this email because we have registered your interest in SQLBI.
unsubscribe me - Privacy Policy