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....
Khristian nbailey In Power BI Service, the RLS role has some limitations about role member:
1. RLS is not applied to the dataset owner.
2. If in a Power BI group workspace, the roles will be applied to read-only members.
If you are the dataset owner and you add yourself under this role, you can run the report to check you can also see complete data in the dataset, as you are the dataset owner. So it's expected that after use Analyze in Excel feature to open the .odc file, you can also see complete data.
In your scenario, you can add a member who is not the dataset owner under role. And in My Workspace, you can pin the report visual to a dashboard and share this dashboard with this member. Then you can get .odc file via Analyze in Excel, then share this file with this user. You will find the user cann't see complete data.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Thank you for the clarification (when RLS was managed in PowerBI.com previously - before it was brought into be managed in Desktop, it was possible to put myself in different roles to test visuals, so this is different behavior now). So the only place we now have the ability to "test" roles is in the PowerBI Desktop, which means we don't have the ability to test any content created on PowerBI.com. This will make it more difficult to troubleshoot end user issues (or validated security) on PowerBI.com content.
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 Yu
Hi v-qiuyu-msft, i have al ready submmited a ticket....
Tks, but i did the things you described.... but it does not work
Hi Khristian,
Based on my test, the RLS is also working in Analyze in Excel feature. Please check if all steps to define RLS are the same as mentioned in this article: Row-level security (RLS) with Power BI (Preview).
Best Regards,
Qiuyun Yu
