topic Re: Creating New Subscription On Paginated Report Shows Permissions Error Message in Report Server

Creating New Subscription On Paginated Report Shows Permissions Error Message

Jimity — Mon, 20 Dec 2021 05:18:20 GMT

Hi,

I'm running with PowerBI Server September 2021. When attempting to create a New Subscription on a Paginated Report, I am brought to the Manager screen of the New Subscription, however as soon as the screen loads I am met with a message.:

"An error has occurred.

You do not have permission for this operation. Contact you administrator to obtain the neccessary permissions."

Security on this Paginated Report is configured by AD Group (which my user account is a member of). I've tried adding ALL available permissions within PowerBI Server with no success, as well as setting security to be the same as the parent folder with no success, and adding AD accounts individually - all with no success. The error also appears to happen whether or not I am an Owner of a Paginated Report.

Has anyone seen this before ?

Re: Creating New Subscription On Paginated Report Shows Permissions Error Message

HashamNiaz — Mon, 20 Dec 2021 11:20:36 GMT

Hi Jimity !

I remember previously there was an issue with Power BI Report Server update. Did you have a previous version of Power BI Report Server where you can check your Subscription issue in isolation. This will help in identifying either the ssue is related to new Report Server release or not.

Regards,

Hasham

Re: Creating New Subscription On Paginated Report Shows Permissions Error Message

Jimity — Tue, 21 Dec 2021 03:31:01 GMT

Hi HashamNiaz,

Unfortunately this is the only PowerBI server we keep, so dont have the luxury of testing with disparate versions in this case.

Re: Creating New Subscription On Paginated Report Shows Permissions Error Message

v-luwang-msft — Thu, 23 Dec 2021 08:52:45 GMT

Hi Jimity ,

you'll need to edit the data source credential after publishing the report. Either to store you user/pass information in the server or enabled the unattended exeution account. When the server runs subscriptions against AS, it needs to have the identity of the user. refer:

https://docs.microsoft.com/en-us/sql/reporting-services/working-with-subscriptions-web-portal?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-the-unattended-exe...

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/store-credentials-in-a-reporting...

Best Regards

Lucien

Re: Creating New Subscription On Paginated Report Shows Permissions Error Message

v-luwang-msft — Wed, 29 Dec 2021 06:12:51 GMT

Hi Jimity ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

Re: Creating New Subscription On Paginated Report Shows Permissions Error Message

Jimity — Mon, 10 Jan 2022 05:23:24 GMT

Hi Lucien,

Apologies for not coming back to you sooner - holidays 😊

I see what you're trying to recommend. I agree it should work. Nothing I attempt though works in this instance. The same error message appears when trying to access those area's to update the information - so effectiovely I'm locked off before I can get started 😢