SQLBI Newsletter #246

NEW ARTICLE

Reading active Power BI security roles in DAX

This article describes how to read the active security roles in a Tabular model for Power BI or Analysis Services. This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for the current user.
Read more

SQLBI+ UPDATE

New content on SQLBI+

We released a new video course and whitepaper on SQLBI+: Inside Calculation Groups is available! A deep dive into calculation groups in DAX that includes best practices and a rich set of examples.
Read more

#246 · Jul 2023

LEARNING

Course calendar

Mastering DAX

	Sep 19-21 - Amsterdam
	Sep 27-29 - Chicago
	Nov 6-8 - Atlanta

Data Modeling

	Nov 7-9 - 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

PREVIEW

Introducing DAX Optimizer

Over the last few years, we have been working in "stealth mode" on a new tool: DAX Optimizer. You can join the waitlist for the beta program or wait a few months for the general availability and the announcement fireworks!
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• DAX Studio 3.0.8 release The latest version of DAX Studio has a large number of bug fixes, plus the support of dynamic format strings in Define Measure and improvements to the metadata refresh for Fabric Direct Lake models. Jun 14, 2023 · DAX Studio
	• The “Visual has exceeded the available resources” error in Power BI Desktop You can simulate the query limits of Power BI service in Power BI Desktop, to diagnose potential issues in reports that consume too much memory or CPU. Jun 18, 2023 · Chris Webb
	• On-premises data gateway June 2023 release It is time to update your data gateway. Mandatory update to support Lakehouse connectivity (Fabric, of course). Jun 21, 2023 · Microsoft
	• On-demand loading of Direct Lake Power BI datasets in Fabric How to analyze in DAX Studio the dynamic loading of columns from a dataset based on Direct Lake in Fabric. We start to discover the innovations that Direct Lake in Fabric brings to Power BI. Jul 2, 2023 · Chris Webb
	• Bravo for Power BI 1.0.4 Important bug fixes in the latest version of Bravo for Power BI. Jun 11, 2023 · SQLBI

SQLBI YOUTUBE CHANNEL