cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to lock filters so that end users cannot change them?

I have a report with filters and I want the end users to not be able to change them. I read that this was added to the November release but I am not able to figure out where the feature is. Does anybody know?

6 REPLIES 6
Highlighted
Anonymous
Not applicable

Re: How to lock filters so that end users cannot change them?

I don't recall if that feature is covered specifically, but I would recommend checking out this video. It covers the latest updates in detail.

 

https://www.youtube.com/watch?v=1xsXXoyTxfk

 

Highlighted
Post Prodigy
Post Prodigy

Re: How to lock filters so that end users cannot change them?

You can do the following for Persistent filters:

gear.pngThen turn off the filter and saveThen turn off the filter and save

 

You can achieve the above via PBI Desktop as well:

 

PBI DesktopPBI Desktop

Lastly, if you are talking about the new filter pane option wherein page level filters can be set and not played with, you will have to turn on this preview feature first and the filter pane has the icons for the option of hiding the filter, locking the selected option which you can use.

 

Lock, hide filter optionsLock, hide filter options

Thank You

Highlighted
Solution Sage
Solution Sage

Re: How to lock filters so that end users cannot change them?

Hi @Anonymous

 

My understanding from your posted question is that you are sharing a power bi report with a user via power bi service and you want to keep the filters fixed. So the users cannot change the filters.

 

This seems to be a concern which we can handle with security roles. You can add the filters to a security role, then add the specific user to the security role in power bi service.

 

 

Security filtersSecurity filters

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

 

 

 

Highlighted
Community Support
Community Support

Re: How to lock filters so that end users cannot change them?

hi, @Anonymous

Turn on the new filter experience

You enable the new experience in Power BI Desktop. Then you can modify filters there or in the Power BI service (https://app.powerbi.com). Because this new filter experience is in Preview, you must first enable it in Power BI Desktop.

 

 

and this is for visual level filter/ page level filter/ report level filter

here is the official documentation for you refer to:

https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: How to lock filters so that end users cannot change them?

The new filter experience seems to have a bug. If you edit any published reports in power bi, it will break any hidden/locked filters. I'm having to download my templates and re-publish to re-enforce the filter locking. Any ideas on how to fix this?

Highlighted
Helper II
Helper II

Re: How to lock filters so that end users cannot change them?

@wgn6011  I am having the same problem:

 

In Power BI desktop, "Filters on this Visual" are inexplicably lost on some of my visuals, but not all, when I publish to Power BI cloud. I am finding this to be especially true with the Sparkline by OKViz custom visual.

 

However, the filters show up correctly in Microsoft Teams.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors