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


Optimizing nested iterators in DAX

This article describes how to consider possible optimization approaches to improve the performance of nested iterators in DAX. Read more »



Time intelligence in Microsoft Power BI

Almost every Power BI model has calculation over dates. Quick measures and DAX functions can help, but what are the best practices in data modeling and DAX expressions to manage also non-standard calculations? Watch now »



Don't miss the last seats available!

Data Modeling - Only two classes until the end of the year:

Data Modeling for Power BI
Oct 10-12 - London, UK
Data Modeling for Power BI
Nov 28-30 - New York, NY, US

Mastering DAX - Last seats in Toronto, Early Bird expiring for San Francisco:
Sep 18-20 - Toronto, ON, CA
Oct 1-3 - San Francisco, CA, US



Latest news on Business Intelligence

• Power BI Server Update - August 2018
Power BI Report Server has finally a new release, which includes many of the features released in Power BI service in the last months. The previous update was in March 2018, but there are many business still running the October 2017 release. And every upgrade in an on-premises environment can be complex because of other dependencies. Test your upgrade before going in production! Read more »
• Sparklines and small multiples in Power BI
Chris Webb wrote an interesting post describing how to leverage the Google Image Charts API to obtain sparklines and small multiples in Power BI. The concept is very appealing, even though relying on a deprecated API could be not rock-solid for a production environment. However, using the same approach there are many other possible applications. Read more »
• Map small multiples in Power BI with Azure Maps API
In fact, Chris Webb used the same approach with the Azure Maps API, which is supported and free up to 250K renders per month. Not free for everyone, but free for many scenarios. And the demo is amazing. Read more »
• Power BI Report URL filter improvements
Microsoft improved how to provide filters to a specific Power BI report through URL parameters. And the URL can be created in a DAX measure, obtaining dynamic links in a Power BI report. Read more »
• Basics of Python in Power BI
Toufiq Abrahams wrote a simple introduction to Python in Power BI. Very useful if you need a practical example to start with. Read more »
• Power BI App Workspaces: the new experience
Adam Saxton introduces the new experience of Power BI App Workspaces in 11 minutes. This feature is in preview and the video could be useful to get a guided tour before trying the new experience for the first time. Watch now »
• On-premises Data Gateway August update
The August update of the on-premises data gateway supports DirectQuery and ODBC drivers for custom data connectors. However, the most important reason to update the on-premises data gateway is to keep it aligned to the Power BI mashup engine. You never know the bugs they solved every month. Read more »