Forum Discussion
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
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!
no, never worked. I initially added the paginated report to the pbi app and thought user will have automatic permissions on the paginated reports dataset. Target is to only add app-users and not NOT manage dataset permissions again/duplicated
I tested it again and can reproduce the behaviour:
- If the paginated reports (which uses dataset1) is added to app --> app-users have no permissions to access the report in the app
- If i add a "dummy" pbidesktop report (which uses dataset1) to the app and "hide" this report in navigation --> user has still no access to app-paginated report
- Only if i unhide the pbidesktop report in app-navigation new app users will get automatically the needed dataset permissions set to "App(Build)" or "App,Build" based on app-permissions-setting "app users can connect to the published report datasets..."
If you assign access to a user in the dataset directly through the workspace, and uncheck both boxes, you'll see they get "Read" permission. If they get this through the app, they get something just labelled "App" permission when you look at the dataset. I believe this is the issue - this is a change where they got Read either through the workspace or the app, so we're looking into this and will expedite a fix if this is the specific issue.
Chris