View this newsletter in your browser


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 »


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!

May 15-17 - Mastering DAX
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!


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.


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 »


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 »