Forum Discussion

kieranW's avatar
kieranW
Advocate I
8 years ago

Power BI Report Server Execution Log

We are running Microsoft Power BI Report Server Version 14.0.600.434. I am trying to extract useful metadata and usage statistics from the ReportServer DB and to do so I am using dbo.ExecutionLog3 as...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

 

kieranW wrote:
2. My ReportServer DB contains a number of ItemAction values which are not present in the generic Report Server documentation. I assume this is because these are ItemActions that are specific to Power BI Report Server. The key ones are: QueryData, AsModelStream, DataRefresh, SaveToCatalog, ConceptualSchema, Execute, Render and Toggle. Can anyone provide definitions for these?

I know that this question ask about 4 years ago, but while I've been searching for ItemAction definition in Power BI Report Server DB, I've Reaching to this post. 

I've found the answer to question number 2 and I will share with you maybe someone like me still searching for it.

 

"Execution log entries for Power BI reports differ from entries for other report types.

  • TimeRendering columns is always 0. Rendering of Power BI reports happens in the browser, not in the server.
  • There are 2 Request Types and subsequent item actions:
    • Interactive: whenever a report is being viewed.
      • ASModelStream: when the data model is streamed to Analysis Services from the catalog.
      • ConceptualSchema: when user clicks on viewing the report.
      • QueryData: whenever data is being requested from client.
    • Refresh Cache: whenever a schedule refresh plan has been executed.
      • ASModelStream: whenever the data model is streamed to Analysis Services from the catalog.
      • DataRefresh: whenever data is being refreshed from one or more data sources.
      • SaveToCatalog: whenever the data model is being saved back to the catalog."

Source: https://learn.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot#executionlog