[ad_1]
Implementing row-level safety in Energy BI is a recurring process for builders. We use varied strategies to take action. Let’s have a look at a few of them.
After we regulate information entry in Energy BI options, we should implement RLS (Row-level safety).
RLS works via the implementation of RLS Roles, which comprise the entry logic to manage information entry.
This logic is outlined by DAX expressions and may be quite simple and all the way in which to very advanced.
As I already wrote a couple of articles about this matter right here on Medium, I made a decision to gather the completely different strategies into one information as an alternative of getting completely different locations the place you should seek for info.
Ultimately, I’ll analyze them side-by-side and suggest which method is the perfect.
I’ll reference my different items if out there. You’ll find the hyperlinks to them within the References part on the finish of this piece.
We have now the next variants to implement RLS:
- Easy Lookup desk
- Utilizing Hierarchies
- Complicated DAX Expressions
- Bonus: Utilizing SCD2 Dimensions
You’ll be able to bounce to the following part in case you are accustomed to constructing RLS roles.
Every RLS function makes use of one of many two primary approaches:
- Figuring out the person
- Making use of an access-logic
The primary method is predicated on a listing of the customers mapped to the information they’ve entry to.
So, when you will have a desk with a listing of customers (within the type of Mail Addresses), you’ll be able to evaluate the present person utilizing the USERPRINCIPALNAME() operate.
The next Measure makes use of this Perform to point out the present person:
Present Consumer = USERPRINCIPALNAME()
Now, I can add it to a Card Visible to get the next outcome:
[ad_2]