cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Highlighted
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 122 members 1,556 guests
Please welcome our newest community members: