Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

radhikar20

Power Bi issue with Row Level Security

Submitted by on ‎01-31-2022 06:40 AM

We've created a dataset that has email addresses and the properties that those email address have access to.

We also have a dropdown of all properties and set it so that depending on which email address is logged in to power bi online, it will filter the dropdown and only show the properties that the email address has access to.

 

However it does not work, it shows all properties for everyone 

Status: Investigating

Hi,

Would you like to post some screenshots of the Power BI report with this issue without the sensitive data if it’s possible and we can help you to check if it’s an existing issue in the Power BI?

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
3 Comments (3 New)
Comments
v-robertq-msft
Community Support
Community Support
‎01-31-2022 06:25 PM
Status changed to: Investigating

Hi,

Would you like to post some screenshots of the Power BI report with this issue without the sensitive data if it’s possible and we can help you to check if it’s an existing issue in the Power BI?

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

radhikar20
New Member
‎02-01-2022 06:52 AM

@v-robertq-msft This is the version: Version: 2.100.1182.0 64-bit (December 2021)

 

So I have a dashboard that has a property dropdown with lots of properties. I also have a table called UserPermissions which has everyone's email addresses and a list of all properties that they should have access to. In Modeling, under Managthis is the security that is set up to limit the properties to the what the user has access tothis is the security that is set up to limit the properties to the what the user has access toThis is the UserPermissions table that has all email addresses and the properties that the email address has access toThis is the UserPermissions table that has all email addresses and the properties that the email address has access tothis is the properties dropdown that should only display the properties I have access tothis is the properties dropdown that should only display the properties I have access toe Roles, Property Row Level,  the table UserPermissions has a filter of [EmailAddress] = USERNAME() also tried USERPRINCIPALNAME() instead of USERNAME() but neither work. 

 

We really just want to filer the property dropdown such that whatever properties my email address is assigned to in the UserPermissions table, only those properties should show up in the dropdown for me to select from. Any idea why this isn't working? 

 

v-robertq-msft
Community Support
Community Support
‎02-01-2022 06:33 PM

Hi, 

Have you published the report to the Power BI service and added some users to the RLS role to make them test the slicer that really can’t work for RLS? What’s more, the test users shouldn’t have the Edit access to the dataset, which will make the RLS can’t work.

If you still have a problem, I suggest you to open a support ticket to get the direct help from the technical support team of Microsoft to have a remote session with you to help you to make sure if this is an issue existing in the Power BI.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses