topic Re: Extract Upload information from on-premises PBI Report Server in Report Server

Extract Upload information from on-premises PBI Report Server

Anonymous — Mon, 12 Aug 2019 21:09:34 GMT

Is there a way to find out when a user uploads a report to an on-premises PBI Report Server?

Thank you,

Sara

Re: Extract Upload information from on-premises PBI Report Server

saykasku — Tue, 13 Aug 2019 07:39:42 GMT

Hi,

You can try this on ReportServer database.

SELECT c.[Path]
      ,c.[Name]
	  ,u.[UserName]
	  ,c.[CreationDate]
  FROM [ReportServer].[dbo].[Catalog] c
  inner join [ReportServer].[dbo].[Users] u
	on c.CreatedByID = u.UserID

When and who create report.

Re: Extract Upload information from on-premises PBI Report Server

d_gosbell — Thu, 15 Aug 2019 23:34:39 GMT

Or you could do a similar thing using the Powershell module https://github.com/Microsoft/ReportingServicesTools/ (or the web api's). Technically Microsoft does not support directly querying the database. If your queries get more complex they can potentially cause blocking which could interfere with the normal operation of the service.