cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wsabuga Frequent Visitor
Frequent Visitor

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

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!

4 REPLIES 4
v-danhe-msft Super Contributor
Super Contributor

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

Hi @wsabuga ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
wsabuga Frequent Visitor
Frequent Visitor

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

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?

wsabuga Frequent Visitor
Frequent Visitor

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

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.

v-danhe-msft Super Contributor
Super Contributor

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

Hi @wsabuga ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 311 members 2,806 guests
Please welcome our newest community members: