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

[RAMUK1]

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

[bassbr2002]

If we were to dynamically display/secure data, it would be interesting to have the current user logged in expose to the interface

[vivekdevalkar]

This is one of those "deal-breaker" kind of features that will determine whether one can use Power BI or not. Absolutely has to be on the immediate roadmap for Power BI.

[massouline]

It's should be a part of the Power Bi platform if Microsoft want to seriously push as a coporate solution

[kirk_potter]

DAX has a USERNAME () function which may help

[vivekdevalkar]

This is one of those "deal-breaker" kind of features that will determine whether one can use Power BI or not. Absolutely has to be on the immediate roadmap for Power BI.

[giuseppe_sica]

It 's too important PowerBi has its own management system for row level security. This will give access to PowerBi to companies that can not buy SQL Server Enterprise.

[datauduong]

We have 1 common data source where we want to be able to show certain data based who is viewing the report, is this currently possible to do ?

[fbcideas_migusr]

This is becoming a serious issue particularly because PowerBi Designer models cannot be promoted into Analysis Services. One of the "simple" ways to do this is to enable USERNAME () function in powerbi.com so that any existing PowerPivot or Designer based model can be secured. Ultimately, security needs to become an integral part of the service just like collaboration but in the short term, making USERNAME () function work would be very helpful.

[darren_mclean]

Yep, agree with other comments. This would make life so much easier.

[vivek_bheda]

Please add this functionality as there is always requirement for sales firm to show saleperson user their own data when they logged in to office 365 tenat. We should be able to write a query that allow us to filter data with the current user logged in