Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Report Server - Access denied to show Home folders

 

Hello,

 

I have setup Power BI Report Server 1 month ago, and all worked until last week.

Service is executed by local user which is administrator.

 

All users which belong to a specific group AD (AD\group-app) which are also admin on the server can't see folders in the home page and there is an error message : "Can't load content folders".

We can see favorites, and when we search a folder that we don't see, we are able to go to the folder and see all contents.

 

In the log RSPortal, there is the following error : 

 

2019-02-11 15:02:39.1748|INFO|33|Received request GET /api/v2.0/catalogitems%28665f3df3-53a2-4c50-a45b-47d68f837cae%29/Model.Folder/catalogitems/| RequestID = s_d12a988f-4694-46d8-9088-1b1fe7d42b77 
2019-02-11 15:02:39.1848|ERROR|33|OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'AD\XXX' are insufficient for performing this operation.
   at Microsoft.ReportingServices.Library.DataSourceCatalogItem.ThrowIfNoAccess(DatasourceOperation operation)
   at Microsoft.ReportingServices.Library.GetDataSourceContentsAction.PerformActionNow()
   at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
   at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetDataSource(IPrincipal userPrincipal, String path)
   at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.<>c__DisplayClass35_0.<TraverseFolder>b__1(FavoriteableCatalogItemDescriptor i)
   at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
   at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at Model.FolderRepository.LoadCatalogItems()
   at Model.Folder.get_CatalogItems()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.SegmentHandlers.PropertySegmentHandler.Handle(Object source, ODataPathSegment segment)
   at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext().| RequestID = s_d12a988f-4694-46d8-9088-1b1fe7d42b77 
2019-02-11 15:02:39.1848|INFO|29|Sending response. Response code AD\XXX 500, Elapsed time 0:00:00,0099879| RequestID = s_d12a988f-4694-46d8-9088-1b1fe7d42b77 

 

 

However, all other users can show all folders in home page according authorized rights.

 

I have tried to give all rights to my AD account in the site settings, and in manage folders tab, but same results.

 

Thanks for your help.

2 REPLIES 2
Jon-Heide
Employee
Employee

Note that server administrators by default have sysadmin permissions to grant access. However, double check that the affected users have both system level and item level permissions. For more info see: 

 

https://docs.microsoft.com/en-us/sql/reporting-services/security/granting-permissions-on-a-native-mo...

 

Anonymous
Not applicable

User which runs report server services is a local user and a member of groups Administrators of the system.

 

AD account that I use is set as System Administrator and System user in Site settings.

 

pbi1.PNG

 

And from side Item management in the homepage, I set in "Manage folder" all roles possible to my account. 

 

pbi2.PNG

 

And even with that, when I come back to the homepage, the same error message.

 

pbi3.PNG

 

However, search works.

 

pbi4.PNG

 

Thanks for your help

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.