topic Re: Power BI Server Subscriptions E-Mail problems when users enter a comment in Report Server

Power BI Server Subscriptions E-Mail problems when users enter a comment

TomD — Thu, 30 May 2024 12:50:41 GMT

I'm on Power BI Report Server Version1.18.8702.6380(September 2023)

When a user with the Manage individual subscriptions privilege creates an email subscription, and enters text in the the Comment section, they get the error below.

An error has occurred.

A delivery error has occurred.

The message in the error logs is;

|ERROR|1362|OData exception occurred: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: A delivery error has occurred. ---> Microsoft.ReportingServices.Diagnostics.Utilities.DeliveryErrorException: A delivery error has occurred. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidExtensionParameter: One of the extension parameters is not valid for the following reason: You do not have permission to modify the value for "Comment".

When the comment is removed, the user is allowed to save the subscription and it runs as expected. Users with the Manage all subscriptions privilege can use the Comments the section without error. I've instructed our users not use the section to work around this problem, but since they see it, they want to use it. Is this a bug or some kind or a setup issue? I can't find anywhere to enable or disable the Comment section.

Re: Power BI Server Subscriptions E-Mail problems when users enter a comment

Anonymous — Fri, 31 May 2024 01:51:00 GMT

Hi TomD ,

The error message suggests a permissions issue with modifying the "Comment" section. Ensure that users with "Manage individual subscriptions" privileges have the necessary permissions to add comments. This might involve reviewing the role definitions and permissions in Power BI Report Server to ensure they align with your organization's policies.

There isn’t a direct setting to enable or disable the Comment section for subscriptions in Power BI Report Server.

Below is the official link will help you:

Grant user access to a report server - SQL Server Reporting Services (SSRS) | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Server Subscriptions E-Mail problems when users enter a comment

TomD — Fri, 31 May 2024 21:41:02 GMT

Hello Anonymous ,

Thanks for your reply. I have verified that users have the Manage individual subscriptions privilege and can create subscriptions. The problem is they can't enter text into the comments section of the subscription and I can't find any way to exclude or include the comments section from that privilege. The documentation seems to suggest that if you have the Manage individual subscriptions privilege, you should be able to use the comments section.

https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/create-and-manage-subscriptions-for-native-mode-report-servers?view=sql-server-ver16#bkmk_create_email_subscription

Re: Power BI Server Subscriptions E-Mail problems when users enter a comment

Anonymous — Mon, 03 Jun 2024 06:37:24 GMT

Hi TomD ,

It appears that users with the “Manage Individual subscriptions” privilege encounter difficulties when trying to create email subscriptions for reports, specifically with the CC/BCC and Comments sections missing. Similarly, in Power BI Report Server, users with the “Manage individual subscriptions” privilege may encounter errors when entering text in the Comment section of an email subscription

Unfortunately, it seems that the comments section is only available when users have the higher role level of “manage all subscriptions,” such as the Content Manager role. If you need to enable the comments section while keeping the role level low (i.e., Manage Individual subscriptions only), you might need to explore alternative approaches or consider adjusting the permissions.

Below is the link will help you:

sql server 2012 - CC/BCC and comments section is missing in the SSRS subscription page - Database Administrators Stack Exchange

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Server Subscriptions E-Mail problems when users enter a comment

TomD — Mon, 03 Jun 2024 20:14:36 GMT

Hello Anonymous ,

Thank you for confirming that. The problem really is then that the people with “Manage individual subscriptions” privilege see the comments section, when it should be hidden like CC/BCC sections.

Re: Power BI Server Subscriptions E-Mail problems when users enter a comment

Anonymous — Thu, 06 Jun 2024 09:39:17 GMT

Hi TomD ,

It is odd , and you can try to update your Power BI Report Server Version to the latest.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Server Subscriptions E-Mail problems when users enter a comment

TomD — Thu, 06 Jun 2024 12:10:44 GMT

Hello Anonymous ,

I updated our test server to Version1.20.8910.25479(May 2024) and the problem still exists.

Here is what users see that only have the Manage individual subscriptions privilege.

Here is the error that happens when a user with the Manage individual subscriptions privilege tries to enter text into the Comment section.