SQLBI Newsletter #160

NEW ARTICLE

COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose conditions, and yet obtain the same result.
Read more

LEARNING

Courses update

We are taking the world events very seriously at SQLBI and working to ensure a quality experience for our students. We have already rescheduled several courses and we will continue to do so if required, also waiving any cancellation fee for students who had asked for a refund. We are very touched by the support we have received and look forward to further cooperate with our students to keep resolving things the best way we can!

#160 · Mar 17, 2020

LEARNING

Course calendar

video courses

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

Data modeling

	Jun 3-5 - Amsterdam
	Jul 22-24 - Sydney
	Sep 21-23 - New York

Mastering DAX

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI Desktop March 2020 update The March 2020 update comes with several new features: new action types for buttons, multi-column sort for tables, dual axis for line charts, and filter pane search. The new ribbon is now active by default. But the enhanced dataset metadata preview feature is crucial, enabling the new features we will see in the coming months. Mar 11,2020 · Microsoft
	• Power BI drill through is now easier to find Marc Lelijveld explains how the new buttons in the latest Power BI Desktop update can improve the discoverability of the drill through feature. Simple and effective. Mar 12,2020 · Marc Lelijveld
	• Connecting SQL Server Profiler To Power BI Premium Chris Webb explains how to get the right XMLA Endpoints to connect SQL Server Profiler (or DAX Studio) to Power BI Premium. It is useful to analyze complex performance and scalability issues. Mar 2,2020 · Chris Webb
	• Improved search experience in the Power BI service Microsoft improved the search experience in the Power BI service, allowing users to search for reports, dashboards, apps, and workspaces from any page in the product. You are now free to randomly put your reports in any workspace, searching for them will be easier. Just kidding! Mar 11,2020 · Microsoft
	• Improved resource governance for Azure Analysis Services Two properties to control the memory consumed by Azure Analysis Services (QueryMemoryLimit and DbpropMsmdRequestMemoryLimit) are now also being applied to MDX queries. You can finally stop your Excel users from slowing down your server. Mar 9,2020 · Microsoft
	• Visualizing Power BI Premium and Azure Analysis Services query parallelism It is complex to understand what happens when multiple users query an Analysis Services model. Chris Webb shows this in a Power BI report that can help you visualize this information. Useful tool to investigate in scalability issues. Mar 9,2020 · Chris Webb
	• Tabular Editor 2.9.5 There were several updates in the last few releases of Tabular Editor - mainly bug fixes. New features will appear in a new major release later this year. In the meantime, keep the tool updated. Mar 12,2020 · Daniel Otykier

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.