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!
Could you try giving individual users access vs. the AD groups?
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.
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?
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.
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?
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.
