Forum Discussion
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?
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
FYI, we're shipping this week the changes to permissions to align paginated reports with Power BI reports for all scenarios. Customers should no longer require "Build" permission when the items are in the same workspace or deployed in an app, and can use the new viewer role same as PBI reports can. This will show up in tenants later this week or over the weekend.
Thanks!
33 Replies
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
I am also facing same issue. Have given App(Build) access to the AD groups. Then too getting this error.
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.
FYI, we're shipping this week the changes to permissions to align paginated reports with Power BI reports for all scenarios. Customers should no longer require "Build" permission when the items are in the same workspace or deployed in an app, and can use the new viewer role same as PBI reports can. This will show up in tenants later this week or over the weekend.
Thanks!
Great news.
Thanks Chris & Paginated Bear!
- nigelreilly how did you resolve this? I am stuck in the same way. please suggest.
Hi ChrisP please share proper docs kindly as there are lots of examples with out an end please share help docs or let me know if rls can be achieved using power bi data set as a source and passing username to @userid when published to power bi service
