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


Applying a measure filter in Microsoft Power BI

This article describes how to use a measure to filter a Power BI visualization and what is the different behavior of a similar filter between different visuals. Read more »



Data Modeling in Europe and North America

There are two editions of the new Data Modeling for Power BI course planned before the end of 2018. Seats are limited, so register before they are sold-out!

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



Latest news on Business Intelligence

• Power BI Desktop July 2018 massive update
There are many small nice improvements in the July 2018 update of Power BI Desktop, but two features rule them all: composite models and many-to-many relationships. Short version: you can mix Direct Query and in-memory storage mode of tables in the same model. Long version: we will cover these features in detail in future articles. Now it is in preview and you should just provide feedback to Microsoft. Composite models are a game changer feature. Read more »
• Power BI and the Future for Modern and Enterprise BI
If you missed the Microsoft Business Applications Summit last week and you have an hour to watch where Power BI is going, the video of the sessions from Amir Netz and Arun Ulag is what you must see. Watch now »
• Power BI Premium Multi-Geo in public preview
You can control where your data is stored in Power BI Premium. This feature has been created to meet regulatory requirements, but it is also important to improve performance of branches running in difference continents. Or when you just run a demo in Australia while your data is in Europe. Read more »
• On comparing Power BI with other tools
Alberto Ferrari wrote a blog post about how to compare Power BI with other tools. Time change the names of technologies, but hard work is still required to create a proper data model. And hard work pays off. Read more »
• How to hide multiple columns in Power BI Desktop
This is certainly a tip that worth a link. You can hide multiple columns in the Relationships view in Power BI Desktop. How? By using the keyboard with the menu button instead of the mouse. Yes, that menu button you never used before. Read more »
• White paper "Planning a Power BI Enterprise Development"
Microsoft published the second version of a white paper written by Melissa Coates and Chris Webb to plan a Power BI deployment in an enterprise environment. In reality, this is a small e-book close to 200 pages. A must read for any Power BI administrators. Read more »
• On-premises Data Gateway July update
Remember to update your on-premises data gateway. The July update introduces custom data connectors in public preview for the Enterprise gateway. One step at a time, the support for different scenarios and data sources is growing every month. Read more »
• Troubleshoot Power Query performance issues
Chris Webb describes how to use Process Monitor to troubleshoot Power Query performance issues with file data sources. And if you don't know Process Monitor, it is a useful tool for many other monitor activities on your PC. Read more »
• Power BI and SharePoint - the road ahead
SharePoint 2019 is available in preview and Christopher Finlan describes what we should expect in terms of on-premises integration for Power BI, Power Pivot, and Reporting Services. Read more »