The best method to implement row-level security in a published Power BI model or SSAS Tabular model consumed from the Power BI service will depend to some degree on your data structure and requirements. The method I demonstrate here is one of the most flexible approaches and one that I commonly use in my projects.
BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, SSAS Administration, SSAS Design
Related Posts
DevOps & CI/CD for Power BI
DevOps isn’t difficult to implement for small and medium-scale projects, and simple things like managing version control in a code repository can save hours of lost time. Organization who are accustomed to managing large application development initiatives might expect to have a fully automated build and deployment process in concert with an Agile delivery process, managed with specialized tools like Jira, GitHub and Azure DevOps.
Power BI Data Modeling Sessions
This is going to be a very busy week for presentations Iam presenting with five sessions scheduled on the topic…
Drill-through from Power BI to Paginated Report – Report Recipe #4
Navigation between reports is the hallmark of an interactive reporting solution, enabling the ability to drill-through and see relevant details…
good explanation on the video, thanks.
thanks for the topic, good work bro
Капсулы Негрустин – отзывы, инструкция по применению – FarmDirect
Hey Paul,
Thanks for sharing, it’s very useful the way that you treat BLANK() value.
Below I share my code DAX that I apply to CRM Dynamic 0365 the idea is :
1/ you look up for the position (and their business unit ) of the person who log in then you stock the result in a variable.
Position:
Sales Rep – only see their own data
Sales Manager – see the whole team data
Business Unit:
Retail
Salon
2/ Then depend on the position you show them what they can see using SWITCH():
//position of UPN
VAR Position_Rule = LOOKUPVALUE(
User[Position],
User[Sales Rep], USERNAME()
)
//business unit of UPN
VAR BU_Rule = LOOKUPVALUE(
User[Business Unit],
User[Sales Rep], USERNAME()
)
RETURN
//if the UPN’s postion is
SWITCH(Position_Rule,
//Representative : display only their data
“Sales Representative”,[Sales Rep] = USERNAME(),
//Sales Manager > display all the data relevant to their team and them self
“Sales Manager”, ([Sales Manager] = USERNAME() || [Sales Rep] = USERNAME()),
FALSE()
)
Dung Anh