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


Optimizing mutually exclusive calculations

This article describes how to optimize DAX expressions that have mutually exclusive calculations, which might cause slow query performance. Read more »



My Power BI report is slow: what should I do?

You have created a wonderful looking Power BI report, but when you open it you find it is not rendering as fast you want. This session covers where should you start analyzing the problem and what can you do to optimize performance. Watch now »



Events in Australia

Marco Russo will be speaking at the Queensland Power BI User Group in Brisbane on July 18, 2018.
Next courses in the country:
Brisbane, Sydney, Melbourne, and Perth (Mastering DAX)
Sydney (Data Modeling for Power BI)
Look at new dates in United States, Canada, and Europe.



Latest news on Power BI and SSAS

• Power BI Desktop June 2018 update
The new Power BI Desktop version has a long-awaited feature: filtering and sorting tables in data view is now possible, as it was always available in Power Pivot and SQL Server Data Tools (SSDT). Other minor updates are related to data connectivity and visuals that you shouldn’t use (pie and donut charts). But one good new feature is enough. Now waiting for big news in July. Read more »
• Subscribe others to email subscriptions in Power BI
It is possible to register other users to email subscriptions in Power BI. The “other” users must have a Power BI Pro subscription, unless you published the workbook in a dedicated capacity with Power BI Premium. There ain't no such thing as a free lunch. Read more »
• Use Outlook Shortcuts to organize your favorite Power BI Reports and Dashboards
If you spend hours on Outlook (who doesn’t?), read the blog post from Christopher Finlan describing how to add shortcuts to Outlook pointing to Power BI reports and dashboards, so you can navigate without leaving your loved Outlook window. Read more »
• Switching from imported data to DirectQuery or Live Connection in Power BI
Daniil Maslyuk recaps how to switch from Import to Live connection and describes how to switch from Import to Direct Query! There are several limitations and caveats, but it is an interesting technique. Read more »
• Power BI REST APIs documentation
The documentation for the Power BI REST APIs is now included on docs.microsoft.com and this is a good thing. The “try it” functionality is not yet available, and this is a bad thing. Someday we’ll have no bad news, maybe? Read more »
• How much does Azure Analysis Services actually cost?
Chris Webb wrote an interesting analysis of how to correctly compute the cost for Azure Analysis Services, including some possible strategy for cost saving that is available in the current billing system. Read more »
• New memory options for Analysis Services
Azure Analysis Services and the latest update of Analysis Services 2017 (CU7) introduced the property IsAvailableInMdx that can save a lot of RAM for large Tabular models. Currently the property cannot be edited with SSDT but only with TMSL and TOM, officially. Or you should do like any professional SSAS developer: move to Tabular Editor and use this property like any other one. More details in a future article on SQLBI. Read more »