Reading active Power BI security roles in DAX

These chapters are auto-generated

182Likes

7,603Views

2023Jul 5

How to read the active security roles in a Tabular model for Power BI or Analysis Services by using a DAX measure. This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for the current user. Article and download: https://sql.bi/803102?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

DAX limitations with row level security RLS

SQLBI

•

8.5K views 1 year ago

Reading active Power BI security roles in DAX

Chapters View all

Introduction

Introduction

Introduction

Example

Example

Example

Solution

Solution

Solution

Setting a security condition

Setting a security condition

Setting a security condition

Active Roles

Active Roles

Active Roles

Checking if the user belongs to a role

Checking if the user belongs to a role

Checking if the user belongs to a role

Automation

Automation

Automation

SQLBI

Reading active Power BI security roles in DAX

Comments 11

Chapters

Introduction

Introduction

Introduction

Example

Example

Example

Solution

Solution

Solution

Setting a security condition

Setting a security condition

Setting a security condition

Active Roles

Active Roles

Active Roles

Checking if the user belongs to a role

Checking if the user belongs to a role

Checking if the user belongs to a role

Automation

Automation

Automation

Description

Chapters View all

SQLBI

Transcript

DAX limitations with row level security RLS

Chapters

Chapters