Grow your YouTube channel like a PRO with a free tool
Get Free YouTube Subscribers, Views and Likes

Dynamic Row Level Security in Power BI

Follow
RADACAD

There are different methods to use rowlevel security in Power BI; You can set up Row Level Security in Power BI itself or through a live connection from a data source such as SSAS Tabular. However, rowlevel security defined in the ways mentioned in the articles above isn’t dynamic. By dynamic rowlevel security, I mean the definition of security is beside the user account information in the data source. For example, when John logs in to the system, based on data tables that show John is the sales manager for a specific branch, he should be able to see only those branches’ data. This method is possible in Power BI using DAX UserName() or UserPrincipalName() function. In this video, I’ll show you an example of dynamic rowlevel security with Power BI’s DAX USERPRINCIPALNAME() function.

posted by ulogoritiko