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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Security - Ability to maintain source security for reports published on BI Sites

The general requirement is that visualizations (Power View, SSRS etc...) must not circumvent existing policies, or introduce yet another set of security policies on top of those already implemented at the source. * For example, a visualization of sales data needs to reflect the policy that account managers can only read sales data for their region. * For performance reasons, this is enforced at the source by injecting predicates into the query based on the end users identity. If identities for end users are not passed down the process chain into the data layer, it leaves us little option but to publish individual reports for every region, which results in an explosion of complexity and numbers of reports, or move the whole model to BISM and manage the policy in yet another place (namely the BISM model). Impact blocking migration to SPO/BI Sites. At least 412 Site Collections with more than 600 Power Views. Impacting Adoption or migration for majority of BPUs - e.g. Finance, LCA, HR, etc
Status: Under Review
Comments
JJDIES
New Member
Very useful improvement, and would simplify a lot the managing of the data.
Megachuckmc
Frequent Visitor
It would be great to be able to implement the equivalent of RLS for Data sources such as Salesforce.com which would be based on the users login credentials that would check a user ID and only return records that match the user. Currently I have to create separate set of reports for each sales person (24+) and set the filters so that they only see their own data.
demo6
New Member
Would greatly ease the deployment of reports and dashboards to users assigned to different accounts or geographical area and filter data only relevant to their filed without having to manage separate reports for each user.
Artur_Esteves
New Member
This is a very very importante feature. It would be a great thing to see this in the near future.
Joseph_Nataraja
New Member
We currently have a large number of leaders and they work on different clients and we need to control what clients they can see. Glad to see that this have been started . Many thanks Power BI team ! Joe
Joseph_Nataraja
New Member
I just quickly tested the row-level security and it works great. I will do more testing and provide our feedback. Thank you so much Power BI team !!.
ankittalele
Regular Visitor
I have gone through a Link :: http://searchsqlserver.techtarget.com/feature/Put-row-level-security-to-work-in-Azure-SQL-databases Is this a feasible solution for access control. If the org. use Azure as there Data Source.
urban1
New Member
Come on Microsoft, community is awaiting this feature long time
nahi
New Member
Very much needed feature. Without this you cannot productize metrics. A deal breaker.
praveeniyer
Regular Visitor
Any update on this?