Mark Beedle on 30 Apr 2020 20:41:40
It would be helpful if Row Level Security could be defined on entities within a Data Flow, so that a single data flow could be used as a repository for different users (with different access rights) to get data.
- Comments (2)
RE: Row Level Security in Data Flows
Added my vote.
We use dynamic RLS to restrict viewers of reporting data from a financials system to see only the same transactions they would be allowed to see on the source system itself. However, we want power users to be able to create their own datasets based upon these restricted data sources and, for example, their own Excel-on-SharePoint sources. This is not possible at present because (a) a dataset cannot bring in data from another dataset and (b) if we use a data flow instead, this blows open the security model.
RE: Row Level Security in Data Flows
Absolutely. I'd be fine with having to have a new dataflow for each change in the relevent role field, or per table. That would let me be certain the data was secured even if a report writer got lazy on the dataset.