Error inserting browser permissions from DB PBIRS

[MPH2019]

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!

[v-qiuyu-msft · Accepted 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