SQLBI Newsletter #166

NEW ARTICLE

Sorting duplicated names in a level of a hierarchy with DAX

This article describes how to use DAX calculated columns to sort names that look like duplicates at a certain level of a hierarchy, but are unique when considering their full path within the hierarchy.
Read more

#166 · Jun 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

Classroom courses

We are rescheduling courses as required by the ongoing situation, and in the meantime we have made sure to keep supporting our students on their learning path.
Check out the latest updates on our training page.

SQLBI YOUTUBE CHANNEL

Latest news

	• DAX Studio 2.11 release The new version of DAX Studio has a countless number of improvements and two new features in preview: Query Benchmark and Query Builder. Yes, a DAX query builder landed in DAX Studio. It's the first version and it's in preview, but it's a good reason to upgrade, isn't it? If you are insatiable, enjoy the new Partitions tab in View Metrics and in VertiPaq Analyzer. Jun 7, 2020 · Darren Gosbell
	• Cast your vote for DAX calculations at the visual level of reports Our proposal for DAX calculations at the level of visuals in reports has received over 1,000 votes in 10 days. The idea is ranked #30 in the top ideas for Power BI. That is an excellent result, but we need another 2,000 votes to be in the top 10. Every vote counts, and your vote is just one click away. Thanks! Jun 8, 2020 · Marco Russo
	• Power BI Report Server May 2020 The new version of Power BI Report Server includes many of the features released in Power BI Service in the last few months. One word of caution: version 15.0.1103.227 seems to force sign-in in Power BI Desktop with custom visuals and there could be a bug when uploading model changes to existing datasets. Do your tests before going in production, or wait for a new build. May 28, 2020 · Microsoft
	• Selectively show report pages for specific users in Power BI Gilbert Quevauvilliers explains how to control which users will see which pages in a report. This goal is achieved by using a combination of Row-Level Security (RLS) and conditional formatting. The article describes the process step by step; it is not trivial but it is well explained. May 26, 2020 · Gilbert Quevauvilliers
	• Importing Office Forms data into Power BI Rui Romano shows you how to automate the import of Office Forms data into Power BI. The process is much easier than it seems; however, it is just the lack of a specific user interface that is challenging here. But Power Query is your friend. Jun 3, 2020 · Rui Romano
	• Tabular Editor 2.10.0 The latest version of Tabular Editor offers a new organization of property categories. It also offers better support to the latest compatibility levels and the enhanced metadata format (v3) to deploy to Power BI Premium. And many small fixes and improvements, as always. Jun 4, 2020 · Daniel Otykier
	• Service Principal access to dedicated capacity XMLA endpoint Daniel Otykier describes in detail how to enable Service Principal access to a Power BI workspace in a dedicated capacity - Power BI Premium or embedded/A SKU. This was the missing part required to run unattended deploy or refresh operations via XMLA endpoint. Yes, continuous integration is now possible! Jun 4, 2020 · Daniel Otykier
	• Optimizing the performance of Power Query merges in Power BI Chris Webb wrote a two-part article describing how to optimize merge operations in Power Query. This technique can be applied to non-foldable data sources like CSV files. Very valuable information. Jun 3, 2020 · Chris Webb
	• Updated whitepaper: Planning a Power BI enterprise deployment The third version of the Microsoft whitepaper, "Planning a Power BI Enterprise Deployment" is available. This article recaps the changes made in each section and provides a link to download the complete whitepaper in PDF format. Jun 3, 2020 · Melissa Coates
	• How to be alerted when Power BI tenant settings change Melissa Coates explains how to receive an alert when a tenant setting has changed in the Power BI Service. If you want to keep the situation under control, this is a must-read. Jun 4, 2020 · Melissa Coates

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.