Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
lherbert501
Post Patron
Post Patron

Dynamic RLS WITHOUT using internal emails

Hi there,

 

I have a problem with dynamic RLS whereby I am aiming to set it up, but not for internal emails.

This will be done either via a generated email or a customer ID.  

 

lherbert501_0-1726165021242.png

 

This works as expected and filters correctly when I select the customer that is manually set up that I store in a table e.g. Customer@Test.com below

 

lherbert501_1-1726165067078.png

 

My issue is how this then works on the service end? I have a list of 10 example customers customer1@test.com, customer2 etc, which all have different ID's.

 

Does anybody know how this would work once the PBI is published and I go into the security of the dataset, as these email addresses or ID's that I will use are not stored on a tenant and are not internal emails therefore won't show as members on the azzure drop down in the image below.

 

These emails will eventually pass through Embedded, but I need to get the testing on the service RLS correct first.

 

lherbert501_2-1726165131080.png

 

Thanks

 

Liam

 

 

 

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @lherbert501 ,

 

it won't work on the service end, this function is designed for the emails, the logged in emails.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

2 REPLIES 2
v-mengmli-msft
Community Support
Community Support

Hi @lherbert501 ,

 

RLS works by automatically applying filters to every DAX query, and Dynamic row level security apply dynamic filters by using userprincipalname() to get the user's account (email) that is currently logged in to Power BI. Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

 

If you want to implement Dynamic row security for external guest users, you need to first add them as guest users in Azure Active Directory and give them access to reports and datasets.

Links to some documentations that will be useful to you.

Distribute content to external guest users with Microsoft Entra B2B - Power BI | Microsoft Learn

Distribute Power BI content to external guest users using Microsoft Entra B2B - Power BI | Microsoft...

 

 

Best regards,

Mengmeng Li

Idrissshatila
Super User
Super User

Hello @lherbert501 ,

 

it won't work on the service end, this function is designed for the emails, the logged in emails.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.