SQLBI Newsletter 12/2018

NEW ARTICLE

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 »

NEW VIDEO

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 »

DATA MODELING

	Jun 26-28 - Amsterdam
	Aug 7-9 - Sydney
	Oct 10-12 - London
	Nov 28-30 - New York

MASTERING DAX

	Jul 18-20 - Brisbane
	Jul 24-26 - Sydney
	Jul 31/Aug 2 - Melbourne
	Aug 20-22 - Perth
	Sep 18-20 - Toronto
	Oct 1-3 - San Francisco
	Oct 10-12 - Amsterdam
	Oct 23-25 - Copenhagen
	Oct 31/Nov 2 - Boston
	Nov 20-22 - London
	Dec 3-5 - Miami

OPTIMIZING DAX

	Jul 5-6 - Amsterdam

VIDEO COURSES

	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	SSAS Tabular
	Power Pivot

COURSES HIGHLIGHT

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.

NEWS DIGEST

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 »

You are receiving this email because we have registered your interest in SQLBI.
unsubscribe me - Privacy Policy