You can now create row-level security without DAX

This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

What's new in the March 2024 Power BI Desktop update Part four of a four-part series of blogs
There are updates to on-object interactions and visual calculations this month, but these major new features still remain in preview. This leaves small changes to data bar and data label formatting - and a new way of doing row-level security - as the only signficant changes in this month's update. What's new in the March 2024 Power BI Desktop update Changing the scope of table and matrix data bars Allowing horizontal alignment of chart data labels You can now create row-level security without DAX (this blog) We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

What's new in the March 2024 Power BI Desktop update

Part four of a four-part series of blogs

There are updates to on-object interactions and visual calculations this month, but these major new features still remain in preview. This leaves small changes to data bar and data label formatting - and a new way of doing row-level security - as the only signficant changes in this month's update.

What's new in the March 2024 Power BI Desktop update
Changing the scope of table and matrix data bars
Allowing horizontal alignment of chart data labels
You can now create row-level security without DAX (this blog)

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 28 March 2024

For many years now you've been able to control who can see which rows of data in your model:

The option to configure RLS, or Row-Level Security.

For example, you might use this to create a London manager role, members of which only have access to view data in the London region:

How this feature used to work - until this month.

However, by default you can now create roles without using any DAX:

I had to click on this button to revert to the old way of doing things so that I could produce the screen-shot shown above.

This is a big improvement!

The same role, but created in the (now) default editor.

It's worth mentioning that although this new editor is now turned on by default, it is technically still in preview:

The enhanced editor is still technically in preview.

This intemediate stage seems odd: if Microsoft trust a feature enough to turn it on by default, surely it's not really in preview any more?

Parts of this blog
What's new in the March 2024 Power BI Desktop update Changing the scope of table and matrix data bars Allowing horizontal alignment of chart data labels You can now create row-level security without DAX (this blog)