Forum Discussion
Persistent Filters are TOO persistent
While Persistent Filters may be great news for some, This is not true for my company. It was time consuming to open every dataset and turn off the feature but I did all of my datasets that way. That was two weeks ago. Today, while pulling some data from my reports on the Service, I noticed that every report was again highlighting Retain filters and when I would navigate away from the report and return, it was in fact retaining filters.
Let me clarify: I turned this feature off in each dataset and completed a republish. It is still retaining filters.
How can I end this madness?
Microsoft rolled out a fix for me this month that may work for others with this issue. If you go to the reports page and click the gear icon for the report you will now see a toggle switch to disable retained filters. Took a while but I am now able to disable these filters on satelite reports. Thanks Microsoft!
13 Replies
HI kcantor,
In fact, I test this feature on my side but it seems not works on power bi server.
Users can still edit on reports who turn on persistent filters feature.
Regards,
Xiaoxin Sheng
Anonymous
My users cannot edit the reports. I am the keeper of the reports. Most of my users are also read only because we have specific filters built into the reports.
This doesn't even seem to be consistent. If I navigate to a report it may or may retain filters depending on the mood of the internet. It should not retain any. I turned that function off and republished all of them.
Today when I go to the main report page, they are disabled but any pages I have pulled out from the original and saved as a stand alone continue to persist filters. They use the same dataset.
Spoke with Microsoft and it has been pushed up to the product team. So very frustrating trying to convey the issue when they only listen to the part they want to hear.
Any help would be appreciated while I wait to hear back from them.
Hi kcantor,
Not sure if this will help or not but if you have a non standard visualisation anywhere in your pbix the persistent filters won't work at all. We have a few pbix files and they never get the 'Return to Default' button highlighted. Maybe if you add a non standard visualisation somewhere it would be a (not very nice and even more time consuming) workaround for the time being?
Thank for the suggestion gooranga1 it would be time consuming but Microsoft seems to be leaning towards the delete and republish path. I have a few large datasets that support about 75 reports. That would take several weeks for me to republish all of them with the customizations that have been added to them on the service since they were built. That is a year or two of work, in some cases, that would need to be recreated.
Does the custom visual need to be on each report page or just one per report?
