Row Level Security in Power BI multidimensional SSAS

[vedran]

Hello guys,

I cannot find any confirmation that is possible to implement Power BI RLS with multidimensional SSAS (on-prem).

Everything that is decribed here https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-row-level-security-onprem... is great for Tabular mode but I haven't find any example for multidimensional mode.

Does someone knows more on this topic?

Thank you

[Anonymous · Accepted solution]

Hi @vedran,

As described in this article, the effective username is passed to the gateway and then onto your on-premises Analysis Services server each time a user interacts a report connected to Analysis Services. The user principal name(UPN), typically the email address that you use to sign in Power BI with is passed to Analysis Services as the effective user.

The UPN is a property of an Active Directory account. That Windows account then needs to be present in an Analysis Services role to have access to the server. Analysis Services can provide filtering based on this account. The filtering can occur with either role based security, or row-level security. You would need to define security roles in your SSAS model in order to implement the role-based security.

Thanks,
Lydia Zhang