cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nigelreilly Regular Visitor
Regular Visitor

RLS in Paginated Reports - User cannot view

Hi,

I have a dataset in Power BI which has RLS rules within in it. The RLS works fine for users.

 

I have now created a connection to that Power BI dataset within Paginated reports. When I publish my Paginated Report to the Power BI app (the same app with the desktop rls report) the user under the RLS can not open it. I am able to run the report as I am a member of the workspace therefore RLS is ignored. The user is a member of the published App.

This is the error they see: Can anyone help?error.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team chrisfin
Power BI Team

Re: RLS in Paginated Reports - User cannot view

Make sure you provide Build permission to the users for the underlying dataset - https://docs.microsoft.com/en-us/power-bi/paginated-reports-embedded-data-source

View solution in original post

10 REPLIES 10
Power BI Team chrisfin
Power BI Team

Re: RLS in Paginated Reports - User cannot view

Make sure you provide Build permission to the users for the underlying dataset - https://docs.microsoft.com/en-us/power-bi/paginated-reports-embedded-data-source

View solution in original post

shanawaz777 Frequent Visitor
Frequent Visitor

Re: RLS in Paginated Reports - User cannot view

I have the same issue. Have given App(Build) access to the AD groups. Still keep getting this error.

KavyaK1208 Frequent Visitor
Frequent Visitor

Re: RLS in Paginated Reports - User cannot view

I am also facing same issue. Have given App(Build) access to the AD groups. Then too getting this error.

Power BI Team chrisfin
Power BI Team

Re: RLS in Paginated Reports - User cannot view

Could you try giving individual users access vs. the AD groups?

KavyaK1208 Frequent Visitor
Frequent Visitor

Re: RLS in Paginated Reports - User cannot view

I have tried giving access to users individually but, until we give them access to workspace, they won't be able to view the Reports. Also we have 300 users, which would be difficult for us in giving the user access individually in the workspace.

shanawaz777 Frequent Visitor
Frequent Visitor

Re: RLS in Paginated Reports - User cannot view

@chrisfin  No, it still does not work with individual member access. This is what I have been trying to do 

(i) There is a paginated report that connects to PowerBI Dataset, both paginated report and PowerBi dataset in a premium workspace.

(ii) There is a PowerBI report as well that connects to the same PowerBI Dataset in the same workspace. (This works)

(iii) The dataset, PowerBI Report, and the paginated report are published to the App.

(iv) For an individual user who is not a member of the workspace, I have given build, read, share permissions to the dataset. 

(v) When the individual member tries to access the paginated report from App, they get this error.

(vi) If I add them to the workspace, they are able to access the report in the App without issues.

 

The issue is with paginated reports connecting to Shared PowerBI dataset published to the App. Please let me know if any further details will help.

 

 

Power BI Team chrisfin
Power BI Team

Re: RLS in Paginated Reports - User cannot view

We've looked at this and can't repro the issue - can you file a support case so it can be looked at by them and see if there's something we're missing?

chrisu Member
Member

Re: RLS in Paginated Reports - User cannot view

@chrisfin Is there any plan to remove the "build" permission requirement to view paginated reports that use Power BI datasets?

 

I am trying to hide or otherwise disable access to all of the fields in a dataset but still use RLS in both a regular and paginated report. 

 

Is there an alternative way to accomplish this?  I can't seem to access hidden fields in Report Builder, so it seems like they must be made available to those I share the report with.  This isn't the case with the regular pbix report--RLS and viewing works just fine with read.  

Shwetha_6608 Visitor
Visitor

Re: RLS in Paginated Reports - User cannot view

@chrisfinHi, I have a similar issue. The premium workspace admin has given build permissions for me to the PowerBI dataset. When I try to connect from Report builder to the powerbi dataset , i get the error saying " The specified Power BI workspace is not found." Am not a memeber or admin in the premium workspace. Please advise.

PowerbiDatasetPaginatedreportissue.PNG


@chrisfin wrote:

We've looked at this and can't repro the issue - can you file a support case so it can be looked at by them and see if there's something we're missing?


 

Helpful resources

Announcements
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.

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.

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: 278 members 2,803 guests
Please welcome our newest community members: