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

2 Replies

  • 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.