See the latest Power BI and SSAS news.
View this newsletter in your browser


Deep dive into DAX evaluation context

This session recorded at Microsoft Business Application Summit summarizes the unifying theory of evaluation contexts based on filter context, row context, filter context operators, and blocking semantic. If you are serious about DAX, this session is a real must.
Watch now »



Understanding Calculation Groups

This second article about calculation groups in DAX explores the properties in detail and then it describes how a calculation item is applied to a measure. Read more »



Upcoming courses

• Learn DAX in Australia:

  Brisbane, AU – July 17-19

  Sydney, AU – July 30-Aug 1

  Melbourne, AU – Aug 6-8 Early Bird expiring soon

  Perth, AU – Aug 14-16 Early Bird expiring soon

• Learn DAX in USA and Canada:

  Chicago, IL – Sep 17-19

  Denver, CO – Oct 2-4

  Washington, DC – Oct 8-10

  Toronto, ON – Nov 12-14



Latest news on BI

• Power BI Report Builder available for Pro datasets
Read it carefully: paginated reports are still a feature for Premium only, but the Power BI Report Builder tool can be downloaded for free and used with your Power BI Pro dataset. This justifies future articles about writing efficient DAX queries! Read more »
• Viewer role for Power BI workspaces
We finally have a viewer role for the new workspace experience in Power BI, making it easier to provide read-only access to reports. Read more »
• New features in Power BI dataflows
The Power BI dataflows have an enhanced computing engine just for the Premium version, and it introduces dataflows templates for everyone - even though templates cannot be customized yet. Read more »
• Power BI reporting API
Power BI has an API to programmatically create a report in an embedded session. There is not much advertising about this API, which can unlock interesting scenarios for developers. Read more »
• DAX Studio 2.9.2
In the last few weeks several fixes have been released for DAX Studio, so it is important to update your copy. Download now »
• Convert M partitions to legacy data sources in Analysis Services
If you create an Analysis Services project today, you likely create M data sources even though you are just mapping tables from a standard data source like SQL Server. Daniel Otykier explains how to obtain a standard (legacy) data source to improve performance and get advantage of Tabular Editor features. Read more »
• Analysis Services as a Power BI dataflows data source: why it is not a good idea
Matthew Roche explains why using Analysis Services as a data source for Power BI dataflows is hardly a good idea. In a few words, you lose the advantages of a semantic model. Matthew completes the description with several diagrams. The simpler, the better. Read more »