View this newsletter in your browser


Using the SELECTEDVALUE function in DAX

This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context.
Read more »


Dashboard Design Rules

Designing a great dashboard in Power BI is not an easy task. So we defined 15 rules to avoid all the common design mistakes and to create dashboards that people like to use everyday! Take a look and download our Rule Reference PDF for FREE »

Dashboard Design Rules

Last Week to Save 20% - Optimizing DAX Video Course

Learn how to detect bottlenecks and improve the performance of your Power BI, Analysis Services and Power Pivot models with this great video course. Hurry up, the lunch offer (20% OFF) expires on Jul 17, 2017. SAVE NOW »

Dashboard Design Rules

Power BI Desktop update, Geographical Heatmap, Data Refresh API, and more...

• Custom visuals store integrated in Power BI Desktop
The July 2017 release of Power BI Desktop includes many new features, as usual. The most important one for custom visuals is the integration of the store: you can browse the visuals from Power BI Desktop and install them directly, without having to download the file from a web browser first. The classification and search functions should be enhanced, but this is a huge usability improvement. Read more »
 • New on-premises data gateway for Power BI
If you use the on-premises data gateway for Power BI in personal mode, you should update it within the end of July. If you have an older version of the gateway, it will stop working in August. This is not an automatic upgrade for the personal mode, and you might have to enter the data source credentials again. Thus, don't wait the last minute and upgrade your personal gateway! Read more »
 • Geographical heatmap visual for Power BI
There is an interesting custom visual for geographical heatmaps available in the store. It is also completely open source on Github and it requires WebGL enabled environments. You can see animation of data changes over time, the demo is really impressive! Read more »
 • Email subscription to Power BI dashboards
You can now subscribe to a Power BI dashboard and not only to Power BI reports. This is a long awaited feature for those wanting to see a single email with an overview of data coming from different data sources and reports. Read more »
 • Data Refresh API in Power BI service
If the scheduled refresh options for Power BI are not flexible enough for your needs, you have now full control thanks to a new Data Refresh API. You can also retrieve the refresh history of your datasets. Is seems that the strongest competitor of Azure Analysis Services is… Power BI! Read more »
 • Planning a Power BI enterprise deployment
Chris Webb and Melissa Coates wrote a large whitepaper about deployment, support, best practices, and licensing of Power BI in an enterprise environment. This is a small book, it is more than 100 pages and it covers a huge number of scenarios. Before reinventing the wheel or losing time in trials and errors, read this whitepaper first. Read more »


SQLBI Training Calendar 2017

We just published our final training calendar for the year 2017.
Save your seats on the upcoming classes in:

Canada   Vancouver
United States   Dallas / New York / Seattle
Europe   Amsterdam / London / Stockholm