DataSources & CatalogItems REST Endpoint permissions are 'insufficient'
I have System Administrator and System User permissions to the Power BI Report Server, but I'm met with with the following error when attempting to access the /Reports/api/v2.0/DataSources and CatalogItems endpoints: { "error":{ "code":"","message":"An error has occurred.","innererror":{ "message":"The permissions granted to user 'DOMAIN\\username' are insufficient for performing this operation.","type":"Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException","stacktrace":" at Microsoft.ReportingServices.Library.DataSourceCatalogItem.ThrowIfNoAccess(DatasourceOperation operation)\r\n at Microsoft.ReportingServices.Library.GetDataSourceContentsAction.PerformActionNow()\r\n at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()\r\n at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetDataSource(IPrincipal userPrincipal, String path)\r\n at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.<>c__DisplayClass37_0`1.<TraverseFolder>b__1(FavoriteableCatalogItemDescriptor i)\r\n at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()\r\n at System.Linq.Enumerable.<OfTypeIterator>d__95`1.MoveNext()\r\n at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()\r\n at System.Web.OData.Formatter.Serialization.ODataFeedSerializer.WriteFeed(IEnumerable enumerable, IEdmTypeReference feedType, ODataWriter writer, ODataSerializerContext writeContext)\r\n at System.Web.OData.Formatter.ODataMediaTypeFormatter.WriteToStream(Type type, Object value, Stream writeStream, HttpContent content, HttpContentHeaders contentHeaders)\r\n at System.Web.OData.Formatter.ODataMediaTypeFormatter.WriteToStreamAsync(Type type, Object value, Stream writeStream, HttpContent content, TransportContext transportContext, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Owin.HttpMessageHandlerAdapter.<BufferResponseContentAsync>d__27.MoveNext()" } } } Why am I able to access other endpoints except these? Is there even a means to adjust this security? Seems off.... I'm using the January 2020 update. Am I the only one that is having this problem or is it normal? Help!
Issue with the REST API and ExcelWorkbooks
I am trying to use the REST API to access an Excel Workbook I have uploaded to the server. When I just query the item using: https://MYSERVER.INT.COM/reports/api/v2.0/ExcelWorkbooks(path='/BusinessReporting/Test/TestFile.xlsx') I get back the following JSON: { "@odata.context":"https://MYSERVER.INT.COM/reports/api/v2.0/$metadata#ExcelWorkbooks/$entity","Id":"ecda6463-3fc4-4329-a56e-b5befcb0dce1","Name":"TestFile.xlsx","Description":null,"Path":"/BusinessReporting/Test/TestFile.xlsx","Type":"ExcelWorkbook","Hidden":false,"Size":9913,"ModifiedBy":"XXXXXX\\MackinBW","ModifiedDate":"2018-10-19T14:11:42.333-07:00","CreatedBy":"XXXXXX\\MackinBW","CreatedDate":"2018-10-19T14:11:06.3-07:00","ParentFolderId":"66dd88d9-5c1c-4203-9492-4de8b6934920","IsFavorite":false,"Roles":[ ],"ContentType":null,"Content":"" } As you can see, it says the ContentType is null, and the Content is also null. If I try and access the content with: https://MYSERVER.INT.COM/reports/api/v2.0/ExcelWorkbooks(path='/BusinessReporting/Test/TestFile.xlsx')/Content/$value I get a 404 error. My understanding of the APIs is that I should get back the contents of the Excel workbook. Is that not correct?