RLS in Power BI Service embedded to Sharepoint Online (Free Users)

[Anonymous]

Hi,

I am trying to publish a report that will allow end users on Free PBI subscription to view their own data only in Sharepoint. The report works perfectly in PBI Desktop, when I use "View as Role" it is exactly how I want it to behave. However when I embed the report to sharepoint online, it's not behaving how it was behaving when I tried it in pbi desktop. 

I followed the instructions to make sure that the Member can only view pbi content and also added the user as a member. I am not sure what I am missing here why the RLS doesn't work. Is it because the user only has a free license? Please help.

Thanks!

[v-danhe-msft]

Hi @Anonymous ,

What kind of your workspace? The new one or the old one? If the new workspace:

https://docs.microsoft.com/en-us/power-bi/service-create-the-new-workspaces

All the roles in the workspace could edit the content in the space so the RLS could not work the it:

https://docs.microsoft.com/en-us/power-bi/service-new-workspaces#roles-in-the-new-workspaces

If the old workspace:

https://docs.microsoft.com/en-us/power-bi/service-create-workspaces

The RLS could work for it if the member could only view the report.

Regards,

Daniel He

[Anonymous]

Also, when the workspace created a group, I added the user in the group and made it as a group owner and I also added the user individually in the workspace app as a member.

[Anonymous]

it looks like I have the old workspace. It was automatically created when I created the sharepoint site. And yes, I set it to "members can only view the content". But the problem now is the user gets an error: The content is not available.

Is there another setting I missed or is it because the user has a free license?

[v-danhe-msft]

Hi @Anonymous ,

Could you please make sure that the users you want to share have acess to your sharepoint? Due to you have set it to "members can only view the content",  so it may limit the users. And also make sure the users are all pro users.

Regards,

Daniel He