Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
For a particular case, I am trying to grant Browser permissions to a user, but I have not been able to do it directly from the PBIRS tables, the error that throws me is: "Cannot find the 'ContentManager' function" and when viewing the Log, tells me: ERROR | 144 | OData exception occurred: Microsoft.ReportingServices.Diagnostics.Utilities.RoleNotFoundException: Cannot find the 'ContentManager' function ..
Reviewing the tables and stored procedures of PBIRS I see that the tables that are needed to assign permissions are: PolicyUserRole and SecData (updating XmlDescription), but when I do it directly in the tables I throw the error.
Try using the storage procedures:
SetPolicy: To update XmlDescription
UpdatePolicyPrincipal: To insert PolicyUserRole for the new user.
UpdatePolicyRole: To update PolicyUserRole that existed previously.
From now, thank you for you help.
(I don't speak ingres, use Google translate)
Cheers!
Solved! Go to Solution.
Hi @MPH2019,
I don't suggest you do any modification to report server database manually. To grant a user permission to access report server via Browser role, please follow this document to do it in Power BI report server web portal. Please note your account should be local Administrators group on the report server computer, or have Content Manager and System Administrator permissions.
Best Regards,
Qiuyun Yu
Hi @MPH2019,
I don't suggest you do any modification to report server database manually. To grant a user permission to access report server via Browser role, please follow this document to do it in Power BI report server web portal. Please note your account should be local Administrators group on the report server computer, or have Content Manager and System Administrator permissions.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
5 | |
2 | |
2 |
User | Count |
---|---|
13 | |
7 | |
6 | |
2 | |
2 |