Forum Discussion
RLS with power bi report server
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
3 Replies
- Greg_DecklerCommunity Champion
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.
- USERWENFrequent Visitor
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
- AdamFHelper I
Please vote on the idea for RLS in Report Server here: