Forum Discussion
RLS Analyze in Excel
Hi nbailey,
We can define the roles in Power BI desktop, but after publishing to the service, we need also add members under this role to take effect for this user. We can also use Test as role to check results. I would suggest you to take a look at this article: Row-level security (RLS) with Power BI (Preview).
Best Regards,
Qiuyun Yui did this.
Well, i faced the samething... now it works....
well, i create my model into powerbidesktop feed it from sql data base....
Then a RLS is created and tested into the powerbi desktop too..
If it work....
A Group is created into powerbi service
the model is published into a GROUP , this group is set "Member can only view powerbi content"
You be sure the user´s you add into that group has a powerpro profile
So try into powerbi publisher for excel, and works....
I tried publishing to a Group Workspace as you suggested (with the view only setting). The user (who has a trial Power Pro licence) could see all of the underlying data using "Analyze in Excel" as long as they avoided the table that has the RLS roles against it.
Well i guess you didn´t get the perfomance you wanted, so, the RLS should be tested....
I worked out what I was doing wrong in my testing. I'm happy that the RLS restrictions are being passed correctly through the Analyze in Excel functionality.
Please, How did you solve it?
I have exactly the same problem.
Thanks!
i did this.
Well, i faced the samething... now it works....
well, i create my model into powerbidesktop feed it from sql data base....
Then a RLS is created and tested into the powerbi desktop too..
If it work....
A Group is created into powerbi service
the model is published into a GROUP , this group is set "Member can only view powerbi content"
You be sure the user´s you add into that group has a powerpro profile
So try into powerbi publisher for excel, and works....