SQLBI Newsletter #168

NEW ARTICLE

This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt.
Read more

SQLBI REPLAY

Use of RANKX in Power BI measures

The RANKX function in Power BI might display an unexpected behavior when applied to a column that has a specific sort order in the data model. This article explains why, and how to address this issue.
Read more

#168 · Jul 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

	• Naming tables, columns, and measures in Power BI This post from Chris Webb introduces a discussion that deserves a longer article, if not a book by itself: A model should use proper names for all the objects. If you have Power BI models with table names starting with Dim or Fact, reading this article is mandatory. Jun 28, 2020 · Chris Webb
	• Power Query data privacy settings deep dive If you have to deal with the Power Query data privacy settings in Power BI (ever seen a Formula.Firewall error?) watch the video recording of this session delivered by Chris Webb at the London Power BI user group. Jun 21, 2020 · Chris Webb
	• Tabular Editor 2.11.5 is ready for Power BI Desktop integration In the last two weeks, several updates and bug fixes were made to Tabular Editor. The upcoming version of Power BI Desktop in July should include the integration with external tools, and the latest Tabular Editor already supports that feature. Jun 30, 2020 · Daniel Otykier
	• Power BI CLI - command line interface Power BI CLI is a multiplatform command-line tool used to interact with the Power BI REST API. It is a work in progress with minimal documentation, but if you want to import a PBIX file with a command-line tool, this is the way to go. Jun 15, 2020 · Jan Pieter Posthuma
	• Adopting Tabular Editor as primary model design tool Paul Turley wrote a blog post explaining why he has given up on Visual Studio to create Tabular models. For the same reasons, you are likely to adopt Tabular Editor as the primary tool to maintain a model in Power BI Desktop starting from the upcoming July 2020 release. Jul 3, 2020 · Paul Turley
	• Power BI theme templates This useful GitHub repository contains snippets to assemble Power BI Themes. If you have ever struggled with the formatting options of the visuals in a theme file, you will appreciate this useful resource. Jun 26, 2020 · David Eldersveld

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.