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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Dimitris_Kats
Helper V
Helper V

Reset / Clear Filters

Dear Members hi,

 

I will need once again your help.

 

I have a pro account in power bi used by several employees.

There is a report with many  slicers and filters.

Each user must configure the filters avery time they enter.
I was wondering if there is a way automatically every time the report loads to clean or reset filters.
I know there is a button for this feature but i really need this to be done automatically, the users must not see the selections of other employees. It's a matter of data protection.

 

Thank you very much in advance!

Thank you very much! 

3 REPLIES 3
collinq
Super User
Super User

HI @Dimitris_Kats ,

 

The fact that you are cheating the system by having multiple users one account is the issue here.  As long as folks are using the same account the report will cache based on the last user's changes.  If you are concerned about data integrity and security you need to give each user their own login.  Then, it is very easy to use RLS to make sure everybody sees their version as they expect it to be seen.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




@collinq Hi.

Thank you very much for your reply.

Sorry but i am not cheating the system...all of these users has the same access to this dataset.
The issue here is that they are constantly asking me how to reset filters.

I was wondering if there is a way to do it automatically. That's all.

Thank you again!

Hi @Dimitris_Kats ,

 

My comment about "cheating the system" is in regards to the licensing - it should be one person has one license and not multiple people sharing one license.  And, that is the filter reset problem that you are running into.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors