Forum Discussion
Block data by filters when sharing to other users
Hi all,
I am wondering if it is possible to share a report or dashboard with other user but blocking some data via filters. Let me show an example: I have a database with data from many cities, but when I share this report to another user, I only want to allow he or she to explore the data from only one city. How can I setup this without deleting the data from the dataset?
Thank you!!
2 Replies
Filters are explicitly not a security feature. Any attempt to use them as such is ill-advised.
To implement role-based security / Row-Level Security (RLS), you'll need to use the Enterprise Gateway with a live connection to an SSAS model, either Multidimensional or Tabular that has RLS enabled. For these connections, PBI will pass EffectiveUserName to the source DB, where security roles can be evaluated, and the returned data includes only that which the user authenticated with the PBI Service has access to.
No other source that supports DirectQuery and no hosted data model can currently support role based security. With any of these sources, the only security is binary - access to the full dataset or no access to the dataset. DirectQuery sources can have stored credentials chosen by the Enterprise Gateway admin. Hosted data models will include whatever data their own source queries include.
Thank you very much. I will look forward into it.
AlexS
