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!
Can you try connecting using the Power BI dataset dialog vs. using the XMLA endpoint via an Analysis Services connection? I have seen a similar message, and it isn't related to build permission but rather some quirks with the XMLA endpoint.
@chrisfin Tried both with direct Power BI dataset (shared and promoted) and Analysis Service connection to Power BI dataset giving the same error message irrespective of the build permission. completely stuck for RLS users. please help.