SQLBI Newsletter #263

NEW ARTICLE

DAX limitations with inactive relationships and row-level security (RLS)

When you apply row-level security to a semantic model, there are limitations in using the USERELATIONSHIP function. This article shows the issues, provides a workaround, and its restrictions.
Read more

DAX UPDATES

DAX visual calculations in preview

In May 2020, we wrote a proposal for visual calculations in DAX, and we are so glad that – a few days ago – Microsoft released a preview of this feature in Power BI Desktop, marking as "Completed" one of our top-voted ideas.

We are going to publish articles and whitepapers about this new feature. They are already in our pipeline.

In the meantime, here come the latest news!

#263 · Feb 2024

LEARNING

Course calendar

INTRO TO DAX - 1 DAY

	Apr 30 - Chicago
	May 27 - Amsterdam

Mastering DAX - 3 DAYS

	Mar 4-6 - Amsterdam
	Apr 15-17 - New York City
	May 6-8 - Seattle
	May 14-16 - Hamburg
	May 22-24 - Copenhagen
	Jun 25-27 - Chicago

ADVANCED DAX - 1 DAY

	May 1 - Chicago
	May 28 - Amsterdam

DAX OPTIMIZATION - 1 DAY

	May 2 - Chicago
	May 29 - Amsterdam

Data Modeling - 3 DAYS

	Jul 2-4 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	DAX Patterns

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI February 2024 updates After a pause in January, this release has many new features: visual calculations, dynamic subscriptions, measure descriptions with Copilot, TMDL integration, and much more. It's time to play! Feb 20, 2024 · Microsoft
	• Visual calculations (preview) This is the feature we had been awaiting for years. It is in preview, there is already a big hype, but you should keep in mind that it is intended to be what its name says: a calculation of numbers you can see in the visual, and not a way to replace DAX (it is all about DAX, after all!). Feb 20, 2024 · Microsoft
	• Generate measure descriptions with Copilot (preview) You can generate measure descriptions if you are lucky or wealthy enough to afford Copilot for Power BI: you need at least a P1 or F64 capacity, Premium per User is not enough. You can also read the first impressions from Marco Russo on LinkedIn. Feb 19, 2024 · Microsoft
	• Leveraging pure Direct Lake mode for maximum query performance If you have tried Direct Lake in your semantic models and you struggle with understanding when the query becomes slow because of fallbacks to DirectQuery, you can now disable the fallback and quickly detect when this is going to happen even with a small amount of data. Feb 21, 2024 · Microsoft
	• Bravo 1.0.7 The latest version of Bravo mainly offers bug fixes, one of which improves the "export data" feature that everybody loves: you can now export very big tables without any memory error! Feb 13, 2024 · SQLBI

SQLBI YOUTUBE CHANNEL