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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PollyPowerBI
New Member

Want to Default Filter based on Row Level Security Role

In Power BI, we have a report that is connected to data model pbix file using "Power BI Dataset" as data source option and we are implementing RLS for that specific report. We are able to successfully implement RLS but we want to know if there is a way to have a default selection for a field in page level or report level filter option or any possible way to force a selection for the field for the user when the report loads up with user specific role.

 

For example, for a user-X,we have a Role-1, for which we have values in a field as A and B. For user-Y, we have Role-2, for which we have values C and D. Now when User-X loads the report then field value should be selected as "A" by default while for user-Y loading the report then field values should be selected as "C" by default in the page or report level filter.

 

Is there a way to achieve this forced selection in the filters for the user when the roles based values are loaded for the field?

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @PollyPowerBI,

 

I have found a blog ROLE-BASED DEFAULT FILTER CONTEXT FOR POWER BI which may help to achieve your requirement.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
nirvana_moksh
Impactful Individual
Impactful Individual

From all my RLS implemnetation's I have not seen the feature wherein a selection can be made based on the user, I would imagine doing something with R or Python (now) might be a route to look into. RLS is only for data restriction and not data selection, but definielty a great idea to post and have in PBI.

 

One other way you could be innovative is to have another column which list the email of the users along with the needed slicer selection and maybe have RLS on that as well? In that way whenever a user logs in he/she only sees the necessary and applicable slicers.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.