Power BI continues to evolve with new features! As
Power BI User Security overview
Power BI is a tool that allows companies to display visuals of their data from multiple applications. For this reason, it would be difficult for the service to attempt to understand the underlying security structure behind each source. So how do you apply end user security? Like other applications, Power BI offers its own security features which you can easily apply to the entire dashboard and datasets. As
Row Level Security
At a high level, RLS involves a two-step process:
1. Your power user or admin can manage roles within the Power BI Desktop app to apply to your tables. Not seeing this feature? Make sure you have downloaded the latest version of the
In this example, I’ve created two roles and applied a DAX expression to each. The DAX expression is used to filter data for each role. Your power user or admin can then apply each role to your Tables.
The SalesRep role simply filters data based on Record Owner of the source data = the logged in Power BI user:
The SalesManager role filters data based on Record Owner’s Manager = the logged in Power BI user:
2. Once the report is published to the Power BI Service, your power user or admin can apply the roles for each dataset.
Select the dataset -> Security:
Add users to each role:
When sharing a Dashboard that utilizes RLS behind it’s datasets, the end users will see only what their Power BI role allows. This works whether the Power BI user is viewing the Dashboard from within Power BI or within an external application, such as Dynamics 365.
For more information on RLS, check out this
Beringer Technology Group, a leading Microsoft Gold Certified Partner specializing in