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

RLS on Pro only App sharing with Free Users viewers

Hi,

 

I am using Row Level Security with my report and I am sharing it into an App. I understand that for the Free Users to view the report and make the RLS work, the Workspace should be in a dedicated Capacity. I only have a Pro license therefore dedicated Capacity is not an option for me. I am Embedding the report in Sharepoint online site. When I let the viewers access the sharepoint online site with my report, they get an error saying This content is not available.

 

Here are my settings:

 

Published the report in an App in power bi Service.

In the workspace, I added the viewer as a Member who can only view the content.

The App has Entire Organization access.

In the Sharepoint online site, the viewer is a member who has read only access.

 

Is there a way for me to share my report that has RLS to the free users?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: RLS on Pro only App sharing with Free Users viewers

Hi @wsabuga ,

 


When I let the viewers access the sharepoint online site with my report, they get an error saying This content is not available.

 


Users viewing a report in SharePoint need either a Power BI Pro license or the content needs to be in a workspace that's in a Power BI Premium capacity (EM or P SKU).

 


Is there a way for me to share my report that has RLS to the free users?

 


Currently, even you add a free user to a classic app workspace. The user cannot view anything. So Pro license is required here.

 

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

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: RLS on Pro only App sharing with Free Users viewers

Hi @wsabuga ,

 


When I let the viewers access the sharepoint online site with my report, they get an error saying This content is not available.

 


Users viewing a report in SharePoint need either a Power BI Pro license or the content needs to be in a workspace that's in a Power BI Premium capacity (EM or P SKU).

 


Is there a way for me to share my report that has RLS to the free users?

 


Currently, even you add a free user to a classic app workspace. The user cannot view anything. So Pro license is required here.

 

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

View solution in original post

BB9 Frequent Visitor
Frequent Visitor

Re: RLS on Pro only App sharing with Free Users viewers

Hello @v-frfei-msft 

 

I am working on something similar and running into issues. Here are the details:

 

We have a premium dedicated capacity. The reports are published to this capacity. I have created a role in PowerBI desktop and used UserPrincipalName() and when I am viewing as a role in the Desktop, it is displaying the right filtered data. However, when I am publishing the report to SharePoint online and embedding the report, the end users are not seeing the filtered data, They are actually seeing everything. Can you please look into this?

 

Thanks.

 

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

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: 61 members 1,370 guests
Please welcome our newest community members: