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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
poli361
Helper I
Helper I

Role level security : Filter Data only on some pages

Hello , I want to apply role level security and I want for a role to filter the company only for some pages not for every page . 

Is there a way to write DAX so the filter will be applied on some pages only ? Or do you have anything else to suggest?

 

Thank you a lot in advance!

6 REPLIES 6
Icey
Community Support
Community Support

Hi @poli361 ,

 

Can this meet your requirements?

Did you know you can now selectively show report pages for specific users in Power BI? - Data Analyt...

 

This is achieved using a combination of Row Level Security (RLS) and conditional formatting. This makes it a secure way of controlling access for specific users.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello and thank you for your suggestion . I have done something similar to this , but this doesn't solve my problem and adds another problem . If you hide the pages , the user in application won't have access but when he export in pdf or powerpoint there is an option to include hidden pages , so then he gain access to those pages I didnt want him to have . 

Whitewater100
Solution Sage
Solution Sage

Hi poli361:

 

Are you talking about the pages in a pbix or a table with page data inside?  Do you have a sample that represents what you are asking?  Thanks..

Whitewater100
Solution Sage
Solution Sage

Hi:

I think you would need to put in a column in your table that groups the specific pages with a common code.

e.g. a column named Include. With yes or no or 1 or 0.

 

Then you could set up the TRUE/FALSE Filter.

 

Whitewater100_0-1648133715688.png

 

Thank you for your reply . 

How this is going to be applied on a page though  ? 

Hi:

Row Level Security is about reducing the rows (filtering out) of a table(s). It's not about which pages to display. You can hide pages and name the report accordingly, but RLS isn't intended for page views.

 

I hope this answers your question.

Thanks..

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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