topic Re: Execution metadata from Power BI Report Server in Report Server

Execution metadata from Power BI Report Server

omnia_saleh — Thu, 01 Feb 2024 07:30:26 GMT

how i get who access my report on power bi report server , who edit on the report and delete and information on each report and who creat it .i mean i need all logs

Re: Execution metadata from Power BI Report Server

ChrisMuthmann — Thu, 01 Feb 2024 14:33:45 GMT

Have a look at the PBIRS metadata in the ReportServerPBI database. Starting with this sql:

Select c.Path, c.Name, u.UserName as CreatedBy from ReportServerPBI.dbo.Catalog c Left Join ReportServerPBI.dbo.Users u on c.CreatedByID = u.UserID;

There are some views as well in this database and [ReportServerPBI].[dbo].[ExecutionLog3] should give you a lot of information regarding the access.

Re: Execution metadata from Power BI Report Server

Anonymous — Fri, 02 Feb 2024 06:28:17 GMT

Hi omnia_saleh ,

As ChrisMuthmann mentioned, there are some system tables and views when you have installed the PBIRS, all the operations you do in PBIRS are logged into the corresponding table, which you can query.

There are some documents that you could refer :

SSRS ReportServer Database Overview and Queries (mssqltips.com),

Report Server ExecutionLog and the ExecutionLog3 View - SQL Server Reporting Services (SSRS) | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Execution metadata from Power BI Report Server

omnia_saleh — Sat, 03 Feb 2024 19:49:02 GMT

Thank you,what Is Type Of Metadata I Will Get?

Re: Execution metadata from Power BI Report Server

omnia_saleh — Sat, 03 Feb 2024 19:50:21 GMT

Thank you,what Is Type Of Metadata I Will Get And What Is The Steps To Get It?

Re: Execution metadata from Power BI Report Server

Anonymous — Mon, 05 Feb 2024 06:16:23 GMT

Hi omnia_saleh ,

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Execution metadata from Power BI Report Server

omnia_saleh — Thu, 08 Feb 2024 11:21:15 GMT

why table [Event] and [history]in database ReportServer has no data in sql server managemet studio?

Re: Execution metadata from Power BI Report Server

omnia_saleh — Thu, 08 Feb 2024 11:21:37 GMT

why table [Event] and [history]in database ReportServer has no data in sql server managemet studio?

Re: Execution metadata from Power BI Report Server

ChrisMuthmann — Thu, 08 Feb 2024 13:29:11 GMT

Same for me and that should be fine.

There is a documentation belonging to the events:

SSRS Subscriptions (What goes on "under the hood")

Re: Execution metadata from Power BI Report Server

omnia_saleh — Sun, 11 Feb 2024 11:41:45 GMT

Is it solved?

Re: Execution metadata from Power BI Report Server

josef78 — Mon, 12 Feb 2024 08:24:19 GMT

I think, Event table is not logging table, I have in this table only ReportRefresh events only during queuing (for very short time).

I History table, I have only snapshots for paginated reports.

Re: Execution metadata from Power BI Report Server

omnia_saleh — Mon, 12 Feb 2024 09:07:03 GMT

i dont have data in table history , Subscriptions i want to see this data

Re: Execution metadata from Power BI Report Server

josef78 — Mon, 12 Feb 2024 10:39:29 GMT

In History table, there no data about subscriptions, but about Snapshots, it is something else.

History of executed subcriptions is in ExecutionLog3 view.