The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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
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.
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.