Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can we restrict Access/Hide slicer, when RLS is applied ?

Hi,

 

I am new to Power Bi.

One PBI report is with me in which RLS is working properly and one avg KPI card is added to the visual by creating the disconnected tables, which shows avg of people.

 

Whenever any logged-in user login, he/she can see their data, and when they are playing with slicers(they can also see the avg KPI card data of others. as this was the requirement from the client to show the average card).

 

applying above Dax as RLS.

 

when user logins below views are generated without selecting the slicers.

But if he/she selects their own slicers, then that's fine.

But if they play around with others, then the visual does not show any data but that card is showing the averages of other ppl also, which is a security violation.

How it can be solved? Any leads would be appreciated.

 

 

 

 

 

Data Protection
Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

     

    Hope to hear from you😀

     

    Best Regards,
    Eyelyn Qin

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

       

      I saw your file, this doesnot solve my problem,
      But In my scenario, I have used Different regions,countries, and usernames as a slicer, for that RLS has been applied.

      So this solution doesn't work here.


      Thanks!!