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


Improving temporal line charts in Power BI with DAX

This article shows how to improve line charts with a date-based axis in Power BI using DAX and making choices in data modeling and visualization properties. Read more »



Black Friday 2018

The best shopping day of the year is around the corner. Don't miss our special discounts by visiting SQLBI website on Nov 23, 2018!

Black Friday 2018



Last classes of 2018 & new dates for 2019!

Last seats for Mastering DAX on December 2018:
Miami  /  Amsterdam  /  Zurich

New dates for 2019 announced:
Seattle - Atlanta - Chicago  /  Vancouver  /  Amsterdam
London  /  Aarhus   (other dates/cities coming soon)



Latest news on Business Intelligence

• Power BI Desktop November 2018
The November 2018 update is huge, and there are many other announcements for the services. The biggest features in the Desktop are Expand & Collapse in Matrix (almost like a PivotTable, but only for rows), new filtering experience, and a new modeling view with editing features (including display folders). There are other small improvements, don't miss the official announcement. Read more »
• Introducing Power BI dataflows
In short, you can copy your M script in Power Query from your Power BI Desktop file to a dataflow, running it on the Power BI service and storing the result of the transformation in a format that can be quickly and easily consumed by several Power BI datasets. The feature is in public preview and it is a more advanced form of self-service ETL that can be easily shared across different models. Read more »
• Paginated Reports (aka Reporting Services) in Power BI
Yes, you can publish a RDL Reporting Services report in Power BI Premium capacity. And this is already another big news. But what if you want to try this feature without Power BI Premium? Read the official instructions from Christopher Finlan (he's the MS Program Manager) to test this feature with the minimum cost. Read more »
• Nested display folders in Power BI
Chris Webb describes how to use one of the many new features in Power BI Desktop November 2018. The display folders have been available in Analysis Services Tabular since 2016, and now they can be defined within a Power BI data model. Chris shows how to create nested folders. This feature is a must for those models with too many measures. Read more »
• New ISINSCOPE function in DAX
Daniil Maslyuk and Kasper de Jonge wrote two good introductions to the new ISINSCOPE DAX function that has been introduced to better support the Expand & Collapse feature of the Matrix visualization in Power BI.
Post by Daniil Maslyuk »   Post by Kasper de Jonge »
• On-premises data gateway November update
There are so many updates in November that you simply need to update the data gateway, too. Don't wait. Read more »
• VertiPaq Analyzer 1.91
The last version of VertiPaq Analyzer only adds a tab to capture the filter expressions used in role based security. The DAX code of these expression can be formatted as any other tab with DAX expressions (measures, calculated columns, and calculated tables). Download now »
• Celebrating 20 years of Analysis Services
Microsoft Analysis Services is 20 years old and the product team wanted to celebrate the event interviewing many influencers in community and development team: Chris Webb, Darren Gosbell, Jeffrey Wang, Josh Caplan, Kasper de Jonge, Marco Russo, Will Thompson. Many stories, jokes, and a look at the future. Watch now »