RLS with power bi report server

[USERWEN]

Hi ,

I'm trying to implement RLS in my reports , I'm using power Bi desktop and publishing the reports on power Bi report server , I'm  using ssas connexion (multidim)  and I'v added a table in SQL to link all my users to region , then i imported it to power Bi and related it to my model

I created roles in power bi using that table but I'm bot able to use this roles in Power Bi report server , Is there any solution to control data in power Bi report server that a user can only see the data of his regions ?

Please helppp

Thankks a looot

[AdamF]

Please vote on the idea for RLS in Report Server here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31122463-dynamic-row-level-securi...

[Greg_Deckler]

See if this article helps:

http://bifuture.blogspot.com/2011/09/ssas-setup-dynamic-security-in-analysis.html

I do not believe that RLS is supported in RS yet but you might be able to get there via the method in that article.

[USERWEN]

Thankks @Greg_Deckler for ur reply , I could implement the RLS in my cube thanks to ur article , but I'm not able to bring the role that i created in the cube in Power bi , Do u have any idea Please?

And thanks again for ur article