SQLBI Newsletter #164

NEW ARTICLE

Highlighting the minimum and maximum values in a Power BI matrix

This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI.
Read more

NEW ARTICLE

Optimizing card visuals in slow Power BI reports

This article describes how to optimize a slow Power BI report with a large number of card visuals, by obtaining the same layout with a smaller number of visuals.
Read more

#164 · May 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

	• Power BI Desktop April 2020 The April 2020 update of Power BI Desktop arrived in... May! This release contains many editing improvements for conditional formatting, themes, and object selection during editing. The preview for change detection ensures an automatic refresh of a report page in case the underlying data changes. But the hidden gem is the CDM Folder view in Azure Data Lake Storage Gen2. You will read more about that in a future article, stay tuned! Apr 22,2020 · Microsoft
	• New Personalize Visuals Experience for Power BI Reports You can now enable users to customize the views of a report without going in edit mode. They can change visualization type, modify measures or attributes used in visualizations, add or remove a legend, and keep track of the changes made. The feature is in preview, time to test it and provide feedback. May 6,2020 · Microsoft
	• Migrating from Analysis Services to Power BI Premium This article written by Richard Tkachuk shows you how to migrate from Analysis Services to Power BI Premium, step by step. It is packed with details that are important to keep in mind if you want to obtain a successful migration, so read it carefully! Apr 27,2020 · Richard Tkachuk
	• Power Query Formatter Finally, a formatter for M code in Power Query! Enter Power Query Formatter – similar to DAX Formatter, kindly provided by Power Pivot Insights. May 8,2020 · Power Query Formatter
	• Debugging Power BI aggregations with DAX Studio Kasper shows us how to use DAX Studio to check whether a Power BI report is using aggregations or not. What would life be like without DAX Studio? Apr 28,2020 · Kasper de Jonge
	• Using the XMLA read/write endpoint without Premium You can use XMLA read/write endpoint with Power BI without Premium by enabling an Embedded capacity just for the time you need to edit a model. It is not free, but it is very affordable since you just pay for the time spent editing the model. Moreover, many companies have free Azure credits. You cannot download a PBIX file for a model modified this way, regardless of whether you are using Premium or Embedded. Shout out to Just for this useful article! Apr 7,2020 · Just Thorning Blindbæk
	• Setting up translations for datasets in Power BI Premium Analysis Services supports model translations. You can use Tabular Editor do manage translations in Power BI Premium. And with the previous piece of news we now know that modeling features available in Premium are also available in Shared capacity if you temporarily enable XMLA read/write endpoint. Interesting times! May 5,2020 · Kasper de Jonge

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.