pbirs tsql shareddatasources
2 TopicsPBIRS Security Roles for adding to favorites
I have configured PBIRS with custom secuirty and by default give all users who authenticate Browse role to the home page. Unforturnately they cannot set reports to favorites. I want to create a custom Browser role and add the ability to add a report to their favorites but I cannot find out what box to check. Below are default setting for the Browser role in PBIRS. Which one(s) should be selected to allow a user to add a report to the favorites?790Views0likes0CommentsTSQL SharedDataSources dbo.Catalog ConnectionString not updated with values in the Web Portal
Hello, Is there an update to this problem? There is a TSQL (List connection strings of all SSRS Shared Datasources) for querying SharedDataSources off of the PowerBIReportServer database. It works fine but when the Shared Datasource is updated from the web portal, it doesn't update the [CONTENT] in the Catalog. It seems that the update is being saved since when I go back to the properties on the web portal, it retains the updated value of ConnectionString. But why would it not reflect on the [CONTENT] in the dbo.Catalog? I understand this was an issue in the previous versions of SSRS. I'm wondering if there's a solution now that it's PBIRS? Thanks in advance! :)621Views0likes0Comments