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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mork
Helper V
Helper V

Best way to share a filtered report and restrict user form removing filters

I have created multiple reports in Power BI Desktop from the same dataset that feeds from Microsoft Project online server using the ODATA feed function. The reports are going to be shared with people from different departments and access levels. After publishing a few reports I noticed that the user has access to the filters that I placed on the report. That is an issue because it gives access to the user to data that he shouldn't have access.

Is there a way to fix that?

If not what's the easiest way to share my pbix files that contain the reports to the users without having that access level issues?

All my pbix files have the same dataset, only the visuals and the filtering changes according to who is going to see the report.

Thank you!

2 REPLIES 2
Greg_Deckler
Super User
Super User

Sounds like you want to implement Row Level Security. This is a brand new feature recently released for Power BI. Here is documentation on it:

 

https://powerbi.microsoft.com/en-us/blog/power-bi-service-march-update-part-two/

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/#limitations

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

 Indeed, finally Role Level Security (RLS) is enabled on the datasets with a basic UI on the PBI management site. You can use a DAX expression to filter on rows in tables based on role membership of the user. See detailed description at:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors