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

[babuk_bi]

How to control the data accessing by user wise, if my data is from text/excel or some other non-Microsoft data sources.

[v-dagrad]

yes, this is vital for sharing data within the business

[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.

[massouline]

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

[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.

[nemecv]

I tried DAX USERNAME () now, but in Power BI Service it returns "guid" which is the same for all users i our tenant. So this does not work !!!

[balsamoma]

'This issue applies to Power BI Preview as well for all data sources that support row level security including: - SQL Server DB - SQL Azure - SSAS MDX

[rencyf]

Any update on adding role based security in PowerBI?

[atendimento1]

I have the same problem...how to filter data according to the logged-in user

[venu_sura]

it will very useful we if get the Row based security with in the Power BI