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: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Eriksson

Row-Level Security Members Combobox Matching Not Working Properly

Submitted by on ‎02-19-2022 10:00 AM

There is a bug in the combobox that is used to add people or groups who belong to a Dataset Security Role in app.powerbi.com. Entering text matches AAD groups using "starts with" matching logic but does not return all matching AAD groups! I was entering 9 characters to match and it returned 8 matching AAD groups and left out at least another 6. To reliably find a match, I had to enter the full name of the desired AAD group which defeats the whole purpose of the combobox! If you aren't going to match on all groups, then make the control a simple drop-down instead of a combobox.

Status: Investigating

Hi,

What do you mean by “Entering text matches AAD groups using "starts with" matching logic but does not return all matching AAD groups”?

 

Would you like to post some screenshots which may show the issue detail more clearly so that it can help us to make sure if it’s an issue in the Power BI RLS.

 

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
‎02-20-2022 06:31 PM
Status changed to: Investigating

Hi,

What do you mean by “Entering text matches AAD groups using "starts with" matching logic but does not return all matching AAD groups”?

 

Would you like to post some screenshots which may show the issue detail more clearly so that it can help us to make sure if it’s an issue in the Power BI RLS.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Eriksson
Regular Visitor
‎02-21-2022 08:46 AM

Sorry, I cannot post screenshots for security reasons so let me explain the issue more clearly.

 

When assigning email addresses or AAD groups to RLS Security Roles for a Dataset, there is a combobox labelled "People or groups who belong to this role". One can start entering an email address or AAD group name and the email addresses and AAD groups that match are listed below (usual combobox behaviour). However, there is a bug. It does not list ALL matching email addresses and AAD groups!  In my case it listed about 8 of them but there were actually a total of about 16. To get the missing one to come up so that I could select one and click the "Add" button, I had to enter more characters in order to narrow the scope of the combobox search so that it matched only 2 names.

v-robertq-msft
Community Support
Community Support
‎02-21-2022 06:41 PM

Hi,

Unfortunately, I can’t reproduce the same issue as yours.

In my opinion, if you want to get the opinions on the RLS Combobox from the Microsoft as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft to have a remote session with you to help them 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