topic RLS with power bi report server in Report Server

RLS with power bi report server

USERWEN — Wed, 20 Dec 2017 13:59:57 GMT

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

Re: RLS with power bi report server

Greg_Deckler — Wed, 20 Dec 2017 14:15:21 GMT

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.

Re: RLS with power bi report server

AdamF — Thu, 21 Dec 2017 02:57:14 GMT

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-security-for-power-bi-report-ser

Re: RLS with power bi report server

USERWEN — Thu, 28 Dec 2017 09:47:14 GMT

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