topic Re: Users unable to create subscriptions in Power BI Report Server in Report Server

Users unable to create subscriptions in Power BI Report Server

DKHUghes55 — Fri, 21 Feb 2025 15:43:15 GMT

Hi Fabric Community,

We have a situation on one of our Power BI Report server sites. We have users who can create subscriptions on reports in one folder but not another. The security for both folders are identical. We use AD groups to control access.

One thing we noticed on the Subscription page is there is a warning symbol on the New Subscription button.

Any clue to why this is happening. I, as an admin, can create one and there are other users in the same AD group that can create subscription.

There doesn't seem to be any reason given all of the settings appear to be the same for the reports and the folders they reside in.

Any Help would be greatly appreciated.

DKHughes55

Re: Users unable to create subscriptions in Power BI Report Server

d_gosbell — Mon, 24 Feb 2025 01:15:13 GMT

If you click on the New Subscription option it should tell you what the issue is. It's most likely that one or more of the data sources for the report are not using stored credentials. Subscriptions need stored credentials since they need to be run at a later time outside of the current users session.

Re: Users unable to create subscriptions in Power BI Report Server

Anonymous — Tue, 25 Feb 2025 03:04:20 GMT

Hi, DKHUghes55

The user needs to verify the permission inheritance status of the folder, go to the security settings of the problem folder, and check whether there is a "Break inheritance" prompt. If so, click "Revert to parent security" to restore the inheritance. At the same time, you need to compare the permission items of the two folders to ensure that the user group has the following permissions:
Browse (required)
Create subscriptions(required)
Manage individual subscriptions (optional, only control delete permissions)

It is also possible that the AD group membership permissions are not fully synchronized, you can force the AD group permissions to be synchronized by force-refreshing the AD group membership via PowerShell:

Get-ADGroupMember "Your_AD_Group" | ForEach-Object { Invoke-PBIReportServerCacheRefresh -User $_. SamAccountName }

You can learn more from the following links:

Roles and permissions in Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn

Grant permissions on a native mode report server - SQL Server Reporting Services (SSRS) | Microsoft Learn

Solved: Creating and or customising user roles on Power BI... - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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