Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Extract Upload information from on-premises PBI Report Server

Is there a way to find out when a user uploads a report to an on-premises PBI Report Server?   Thank you,   Sara
Need Help
Power BI Report Server
saykasku's avatar
saykasku
Icon for Resolver I rankResolver I
7 years ago

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.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

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.