Forum Discussion
Disable Commenting on PowerBI Report Server
Wondering if there is a way to prevent commenting on a desktop report. Looking at the table dbo.upgradeinfo (within the reportserver - database), there is a item called "enablecomments" with a status of True. Tried to replace with a false, but once I bounce the website, the value is restored. Dont know if this even refers to commenting on a desktop report, but was wondering if anybody has came across this and knows of a solution.
Thanks.
Okay... so this is a dirty solution, but ended up putting in a trigger on the comments table of which desktop reports I dont want to allow commenting. Below is the *cough* "solution", which we also capture the comment and user name to have it send via email. If a user does attempt to submit a comment, they will receive the error message "An error has occurred. Something went wrong. Please try again later.". I believe the error is a result to not sending anything back from the post. Out of curiosity I imagine if you didn't want the error message, you could have the stored procedure "GetCommentByCommentID" return false data.
declare @commentid int, @comment varchar(2048), username varchar(260if (select count(*) from dbo.[Catalog] a
join inserted b on a.ItemID = b.ItemID
where Name like '%your condition%') > 0
begin
select @commentid = a.commentid,@comment = a.[Text], username = coalesce(b.UserName,'Unknown') from inserted a
left join dbo.Users b on a.UserID = b.UserIDexec dbo.DeleteComment @commentid
end
3 Replies
Okay... so this is a dirty solution, but ended up putting in a trigger on the comments table of which desktop reports I dont want to allow commenting. Below is the *cough* "solution", which we also capture the comment and user name to have it send via email. If a user does attempt to submit a comment, they will receive the error message "An error has occurred. Something went wrong. Please try again later.". I believe the error is a result to not sending anything back from the post. Out of curiosity I imagine if you didn't want the error message, you could have the stored procedure "GetCommentByCommentID" return false data.
declare @commentid int, @comment varchar(2048), username varchar(260if (select count(*) from dbo.[Catalog] a
join inserted b on a.ItemID = b.ItemID
where Name like '%your condition%') > 0
begin
select @commentid = a.commentid,@comment = a.[Text], username = coalesce(b.UserName,'Unknown') from inserted a
left join dbo.Users b on a.UserID = b.UserIDexec dbo.DeleteComment @commentid
endYeah I'd really appreciate the capability of turning this off globally as well. If you want to drive people through the portal, then allowing content editors the ability to edit/delete/suppress comments would be useful.
