Forum Discussion
Exclusive report location wise
Hi there!
So the company that I'm working in has only one microsoft account through which every power bi report gets published. It has multiple regions like chicago Philadelphia etc. I want each site to have exclusive view ( meaning chicago can't view philadelphia's report so on and so forth). I've synced filters and used text filters and set up passwords for each site. First of all on the first page where user can select site once he types in his code all options are available on the slicer I want the slicer to be empty and show only the selected site secondly I don't want previously selected options to appear in the text filter or the slicer.
Thanks
8 Replies
- Stachu
Community Champion
Is the report published in the Premium Service? If the report readers have different accounts then you can use RLS:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rlsOtherwise you will have to split the report by location, e.g. with M parameters:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters Isn't there a way a user inputs a code(Text filter) for a specific location and automatically based on that code the report gets filtered according to it?
- AlexisOlson
Super User
That's pretty much what Row Level Security (RLS) does except it relies on the user's login info for filtering rather than having them input a code (which wouldn't be a secure way to do this).
I know but I'm limited by the fact that the firm has only one microsoft account.
