SQLBI Newsletter 6/2018

NEW ARTICLE

Capturing Power BI queries using DAX Studio

This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries. Read more »

COURSES HIGHLIGHT

Mastering DAX in May - Atlanta and London

In May, you can learn DAX in US and UK. Don’t wait the last minute and register now to our classes to take advantage of the Early Bird!

	Atlanta May 15-17 - Mastering DAX
	London May 16-18 - Mastering DAX

Are you looking for a Data Modeling course? The Early Bird for the course Data Modeling for Power BI in Seattle (Apr 23-25) expires next week!

COURSE UPDATE

Mastering DAX - Spanish subtitles

You asked, we listened! The Mastering DAX Video Course now includes subtitles in Spanish language. Try for FREE »

To activate subtitles, just click on the CC button of our video player and select your language.

BI NEWS DIGEST

Power BI persistent filters, Report Server March 2018 update and more...

	• Persistent filters in Power BI service Power BI service has now persistent filters. This is a welcome feature if you navigate a report online and you want to keep the selection of filters and slicers in your next visit to the same report. You can always reset the filters to the default, which are those defined in the original report. Read more »
	• Power BI Report Server March 2018 update The long-awaited Power BI Report Server March update is finally available. There are many updates server-side, and you can use the Power BI Desktop March 2018 version to design reports now. For a few weeks, no more version-nightmare for Power BI Desktop if you publish on both Report Server and Power BI service. Until the next update in April, at least. Read more »
	• Data conversion and ascribed data types in Power Query Miguel Escobar wrote an interesting article describing the differences between data type conversion and ascribing data types in Power Query. The concept can be applied to both Power BI and Excel, and it is important to avoid unnecessary conversions. As any powerful tool, it can be also dangerous if used the wrong way! Read more »
	• Power BI for Mixed Reality app The Power BI app for Mixed Reality is available in preview. If you are looking for a good excuse to buy HoloLens, now you have a very good one! Read more »
	• Microsoft demo report for the Gartner Bakeoff Microsoft presented an interesting Power BI demo at the Gartner Data and Analytics summit’s “Bakeoff” competition. The best part is that they described how they build this solution with some technical details and, most important, by sharing the PBIX file. It’s a good storytelling demo. Read more »

SQLBI REPLAY - APR 28, 2015

From SQL to DAX: Joining Tables

In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX. Read more »